ä¼ä¸ç®¡çå¨ä¸çToolsï¼Database Maintenance Plannerï¼å¯ä»¥è®¾ç½®æ°æ®åºçå®æèªå¨å¤ä»½è®¡åã并éè¿å¯å¨Sql server Agentæ¥èªå¨è¿è¡å¤ä»½è®¡åãå
·ä½æ¥éª¤å¦ä¸:
1ãæå¼ä¼ä¸ç®¡çå¨ï¼å¨æ§å¶å°æ ¹ç®å½ä¸ä¾æ¬¡ç¹å¼Microsoft SQL Server-->SQL Serverç»-->åå»æå¼ä½ çæå¡å¨
2ãç¶åç¹ä¸é¢èåä¸çå·¥å
·-->éæ©æ°æ®åºç»´æ¤è®¡åå¨
3ãä¸ä¸æ¥éæ©è¦è¿è¡èªå¨å¤ä»½çæ°æ®
4ãä¸ä¸æ¥æ´æ°æ°æ®ä¼åä¿¡æ¯ï¼è¿éä¸è¬ä¸ç¨åéæ©
5ãä¸ä¸æ¥æ£æ¥æ°æ®åºå®æ´æ§ï¼ä¹ä¸è¬ä¸éæ©
6ãä¸ä¸æ¥æå®æ°æ®åºå¤ä»½è®¡åï¼é»è®¤çæ¯1å¨å¤ä»½ä¸æ¬¡ï¼ç¹å»æ´æ¹éæ©æ¯å¤©å¤ä»½åç¹ç¡®å®
7ãä¸ä¸æ¥æå®å¤ä»½ç£çç®å½ï¼éæ©æå®ç®å½ï¼å¦æ¨å¯ä»¥å¨Dçæ°å»ºä¸ä¸ªç®å½å¦ï¼d:\databakï¼ç¶åå¨è¿ééæ©ä½¿ç¨æ¤ç®å½ï¼å¦ææ¨çæ°æ®åºæ¯è¾å¤æ好éæ©ä¸ºæ¯ä¸ªæ°æ®åºå»ºç«åç®å½ï¼ç¶åéæ©å é¤æ©äºå¤å°å¤©åçå¤ä»½ï¼ä¸è¬è®¾å®4ï¼7天ï¼è¿çæ¨çå
·ä½å¤ä»½è¦æ±ï¼å¤ä»½æ件æ©å±åé»è®¤çæ¯BAK
8ãä¸ä¸æ¥æå®äºå¡æ¥å¿å¤ä»½è®¡åï¼çæ¨çéè¦åéæ©
9ãä¸ä¸æ¥è¦çæçæ¥è¡¨ï¼ä¸è¬ä¸åéæ©
10ãä¸ä¸æ¥ç»´æ¤è®¡ååå²è®°å½ï¼æ好ç¨é»è®¤çé项
11ãä¸ä¸æ¥å®æ
12ãå®æåç³»ç»å¾å¯è½ä¼æ示Sql Server Agentæå¡æªå¯å¨ï¼å
ç¹ç¡®å®å®æ计å设å®ï¼ç¶åæ¾å°æ¡é¢æå³è¾¹ç¶ææ ä¸çSQL绿è²å¾æ ï¼åå»ç¹å¼ï¼å¨æå¡ä¸éæ©Sql Server Agentï¼ç¶åç¹å»è¿è¡ç®å¤´ï¼éä¸ä¸æ¹çå½å¯å¨OSæ¶èªå¨å¯å¨æå¡
13ãå¯ä»¥è®¾ç½®èªå¨å¯å¨sql server Agent:è¿è¡Services.mscï¼è®¾ç½®sqlserverAgent为èªå¨å¯å¨ã
14ãä¿®æ¹è®¡åï¼
æå¼ä¼ä¸ç®¡çå¨ï¼å¨æ§å¶å°æ ¹ç®å½ä¸ä¾æ¬¡ç¹å¼Microsoft SQL Server-->SQL Serverç»-->åå»æå¼ä½ çæå¡å¨-->管ç-->æ°æ®åºç»´æ¤è®¡å
温馨提示:答案为网友推荐,仅供参考