MS SQL2000数据库自动备份的几种方法(国外英文资料).doc

MS SQL2000数据库自动备份的几种方法(国外英文资料) Several methods of automatic backup of MS SQL2000 database.Txt First, simple and practical backup method: The Tools Database Maintenance Planner in the enterprise manager can set the databases regular automatic backup plan. And automatically run backup plans by starting Sql server Agent. The concrete steps are as follows: 1, open the enterprise manager, Microsoft SQL Server--SQL Server in open group -- your server in the console double-click to open the root directory 2, then the tools above menu -- select database maintenance plans Optimization of information update data 3, the next step to automatically backup / next, here are generally not to choose check data integrity -- next, also generally do not choose 4, next to specify the database maintenance plan, the default is the 1 week backup once, click change, select the backup point after each day to determine 5, the next step to specify the backup disk directory, select the specified directory, if you can create a directory in the D disk, such as d:\databak, and then choose to use this directory here, if your database is more the best choice to establish a subdirectory for each database, and then choose to delete the backup as early as a few days ago, the general settings 4 - 7 days, the specific requirements to backup your backup file extension, the default is BAK Step 6, specify the transaction log backup plan, you need to do the next step to select -- generated report, generally do not choose the maintenance plan history taking the next step, the best use of the default options - next step to complete 7, after the completion of the system is likely to suggest that Sql Server Agent service is not started, the first point to determine the schedule set, and then find the desktop on the right side of the status bar in the SQL green icon, double click open, select the Sql Server Agent in the service, and then click the arrow on the bottom of the operation, select the auto start s