Set up SQL Server to automatically back up databases on a regular basis

server| Backup | data | database
Tools,database Maintenance Planner in Enterprise Manager, you can set up a regular automatic backup schedule for the database. and run the backup schedule by starting the SQL Server Agent. The specific steps are as follows:

1, open Enterprise Manager, in the console root directory in turn open Microsoft SQL Server-->sql Server group--> 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 on the change to select a daily backup point to determine
5, next specify the backup disk directory, select the specified directory, such as you can create a new directory in D disk such as: D:\databak, and then choose to use this directory here, if your database is more than best choose to create subdirectories for each database, and then choose to delete the backup earlier than how many days ago, Generally set 4-7 days, this depends on your specific backup requirements, backup file extension default is Bak
6, next specify the transaction log backup plan, see your needs to make a choice--> next to generate reports, 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.

Modification Plan:
Open Enterprise Manager, click to open Microsoft SQL Server-->sql Server group in the console Root--> double hit Open your server--> admin--> Database Maintenance plan