Set SQL Server Auto Backup Database

xiaoxiao2021-03-06  57

Tools, Database Maintenance Planner in Enterprise Manager, you can set up a regular automatic backup plan for the database. And run the backup plan by launching the SQL Server Agent. Specific steps are as follows:

1. Open Enterprise Manager, click on the Microsoft SQL Server -> SQL Server Group -> Double click on your server 2 in the root directory of the Control Station -> Select the Database Maintenance Planner above the menu 3, Next Select data to be automatically backed up -> Next update data optimization information, here usually do not do the choice -> Next check data integrity, it is generally not selected 4, the next specified database maintenance plan, default One week backup once, click Change Select Once After you back up, you can determine 5. Next Specify the backup disk directory, select the specified directory, such as you can create a directory in D: DATABAK, then choose to use here This directory, if your database is better to choose to create a subdirectory for each database, then select Remove how many days ago, you will set 4-7 days, see your specific backup requirements, backup file extensions The default is BAK6, the next specified transaction log backup plan, see your needs to do the selection -> The report to generate, generally do not choose -> Next Maintenance plan history, it is best to use the default option -> The next step is 7. After the system is complete, the system is likely to prompt the SQL Server Agent service to not start, first determine the completion plan setting, then find the SQL green icon in the rightmost status bar in the desktop, double-click Open, in the service Select SQL Server Agent, then click Run Arrow, select Automatically Start Services 8 when starting OS, you can set the startup SQL Server Agent: Run Services.msc, set SQLServerAgeT to start automatically. Modifying Plan: Open Enterprise Manager, click on Microsoft SQL Server in the Content Managed Directory -> SQL Server Group -> Double click to open your server -> Management -> Database Maintenance Plan

?

转载请注明原文地址:https://www.9cbs.com/read-118086.html

New Post(0)