Shulou(Shulou.com)05/31 Report--

How to set sql server to automatically back up the database on a regular basis, this article introduces the corresponding analysis and answer in detail, hoping to help more partners who want to solve this problem to find a more simple and easy way.

Tools,DatabaseMaintenancePlanner in Enterprise Manager, you can set up a schedule for regular automatic backups of databases. And automatically run the backup schedule by starting SqlserverAgent.

The specific steps are as follows:

1. Open Enterprise Manager, click MicrosoftSQLServer-- > SQLServer Group-- > double-click to open your server in the root directory of the console.

2. Then click tools in the menu above-> Select Database maintenance Planner

3. Next, select the data to be backed up automatically-- > update the data optimization information in the next step. Generally, you do not need to make a choice here-- > check the data integrity in the next step, and generally do not select.

4. Specify the database maintenance plan in the next step. The default is to back up once a week. Click change and select the point after backup every day.

5. Next, specify the disk directory for backup, and select the specified directory. For example, you can create a new directory on D disk, such as: d:\ databak, and then choose to use this directory here. If you have a large number of databases, you'd better choose to establish a subdirectory for each database, and then choose to delete backups earlier than how many days ago. Generally set up for 7 days. Depending on your specific backup requirements, the backup file extension defaults to BAK.

6. Specify the transaction log backup plan in the next step, depending on your need to make a choice-- > the report to be generated in the next step is generally not selected-- > the next step to maintain the plan history, it is best to use the default option-- > complete the next step.

7. After completion, the system is likely to prompt that the SqlServerAgent service has not been started, click to confirm the completion plan setting, then find the SQL green icon in the rightmost status bar of the desktop, double-click to open, select SqlServerAgent in the service, and then click the run arrow to start the service automatically when you start OS.

8. You can set the startup sqlserverAgent: run Services.msc, and set sqlserverAgent to start automatically.

Modify the plan: open Enterprise Manager, click MicrosoftSQLServer-- > SQLServer Group-- > double-click to open your server-- > Administration-- > Database maintenance plan in the root of the console.

This is the answer to the question about how to set sql server to back up the database automatically on a regular basis. I hope the above content can be of some help to you. If you still have a lot of doubts to be solved, you can follow the industry information channel for more related knowledge.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.