In the SQL Server 2008 database. In order to prevent the loss of data we need to back up the database on time. If you want to back up every day, the manual backup will be very troublesome, automatic backup of the words do not need to be so troublesome, as long as the set up, the database will automatically be in the time period you set up. So how do you set up automatic backups? Here are the explanations for you.
Tools/Materials
Method/Step
- 1
In the PC Start menu, select "SQL Server Management Studio" to double-click. In the interface that appears, click the "Connect" button.
- 2
In the Microsoft SQL Server Management Studio interface that appears, select Maintenance plan under Administration, right-click the maintenance plan, click Maintenance Plan Wizard,
- 3
In the SQL Server Maintenance Plan Wizard interface that appears, click Next
In the interface that appears, write the name and description. Then click on "Change" to set top backup plan
In the job schedule properties interface that appears, change the execution time, that is, how often to back up. This should be a daily backup. The interval is changed to "1" and the execution time is 0:00:00 automatically back up the data at 0 points per day.
Once you've changed it, you can see "executing in 0:00:00 every day." Plans will be used from 2014-5-16 onwards. "Then click on the" Next "button
Select the database file that you want to back up in the Select Maintenance task interface. Then click Next.
In the Select Maintenance task order, you can move the order of the database files that you want to back up. then click "Next"
In the Define backup database complete interface, select the database file from the drop-down menu in the back of the database. Then click on the "OK" button
Select the backup path in the Define backup database complete interface. Then click "Next"
Set the path to the report text file in the Select report options interface. Then click "Next"
In the "Completing the wizard" screen that appears, you will see the details of setting up the backup.
This allows the database to be automatically backed up successfully.
END
Precautions
How SQL Server 2008 automatically backs up the database