Set SQL Server to automatically back up databases on a regular basis
Set SQL server to regularly and automatically back up databases
Tools and Database Maintenance Planner in Enterprise Manager can set Regular automatic backup schedules for databases. Start the SQL server Agent to automatically run the backup plan. The procedure is as follows:
1. Open the Enterprise Manager and click Microsoft SQL Server> SQL Server group in the root directory of the console. Double-click to open your Server.
2. Click Tools in the menu above --> select Database Maintenance Scheduler
3. Next, select the data to be automatically backed up --> next, update the data optimization information. You do not need to select here --> next, check data integrity.
4. Next, specify the database maintenance plan. The default one-week backup is performed. Click "change" and select "backup every day". Click "OK ".
5. Next, specify the backup disk directory and select the specified directory. For example, you can create a directory on disk d, such as d: \ databak, and then select to use this directory here, if you have a large number of databases, it is best to create a subdirectory for each database, and then select the number of days before the deletion of the backup, generally set to 4-7 days, depending on your specific backup requirements, the default backup file extension is BAK.
6. Specify the transaction log backup plan in the next step. Check whether you need to select the report to be generated in the next step. Generally, do not select the report, it is best to use the default option --> next step to complete
7. After completion, the system will probably prompt that the SQL Server Agent service is not started. First, click confirm to complete the plan settings, find the SQL green icon in the rightmost status bar of the desktop, and double-click it, select SQL Server Agent from the service list, and click the run arrow to automatically start the service when the OS is started.
8. enable SQL server Agent Startup: run Services. msc and set sqlserverAgent to Automatic startup.
Modify plan:
Open the Enterprise Manager and click Microsoft SQL Server> SQL Server group> double-click your Server> Manage> database maintenance plan in the root directory of the console.
