Scheduled Automatic Backup of the MSSQL database.
Scheduled Automatic Backup of the MSSQL database.
Use the Enterprise Manager to set a regular automatic backup plan for databases.
1. Open Enterprise Manager and 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 to select the backup date and time,
5. Next, specify the backup disk directory, select the specified directory, and then select the number of days before the backup, and choose to delete the backup once a week. The specific backup depends on your 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.