On the Define Back Up Database (Full) Task page, set up the full backup according to the following instructions.
On the Select Maintenance Task Order page, leave the order as shown, and then click Next. On the Select Maintenance Tasks page, select the Back Up Database (Full), Back Up Database (Differential), and Back Up Database (Transaction Log) check boxes, and then click Next. On the Select Plan Properties page, specify a name for the plan, select Separate schedules for each task, and then click Next. On the welcome page of the wizard, click Next. In the Object Explorer pane, go to Management > Maintenance Plans, right-click Maintenance Plans, and select Maintenance Plan Wizard. Launch the SQL Management Studio and log in. On the General tab, select Automatic as the startup type, and then start the service. Cick the Recovery tab, and set the failure value to Restart the Service. On the server, open the Run dialog box, type in services.msc and press Enter.įind the SQL Server Agent service in the list and double-click it. The maintenance plan depends on this service to run. Verify that the SQL Server Agent service is running and set to automatic. Troubleshoot errors by viewing the job history. Set up the transaction log cleanup task. In this example, the maintenance plan is set up with full backups, differentials, and transactions logs. When you create a maintenance backup plan in SQL Server 2008 R2, you must identify how you want the plan to be set up.
0 kommentar(er)
