Periodic automatic backup schedule for MSSQL databases. _mssql

Set up regular automatic backup schedules for the database through Enterprise Manager.
1, open Enterprise Manager, double hit Open your server

2, then click the Tools in the above menu--> Select Database Maintenance Planner

3, next select the data to be automatically backed up--> next update data optimization information, here generally do not have to choose--> Next Check data integrity, also generally do not choose
4, the next step to specify the database maintenance plan, the default is 1 weeks backup, click Change Select the date and time of backup to determine,

5, next specify the backup disk directory, select the specified directory, and then choose to delete the backup earlier than how many days ago, select one weeks to delete a backup, specific backup look at your request, backup file extension default is Bak

6, next specify the transaction log backup plan, see you need to make a choice--> next to generate the report, generally do not choose--> Next maintenance Plan history, preferably with the default option--> next step to complete


7, after the completion of the system is likely to prompt the SQL Server Agent service is not started, the first point to determine the completion plan, and then find the desktop rightmost status bar in the SQL Green icon, double-click Point Open, select SQL Server Agent in the service, and then click the run arrow, Start the service automatically when you start the OS


8, you can set up startup SQL Server Agent: Run services.msc, set SQLServerAgent to start automatically.