![]() ![]() 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |