One, a single database backup through Enterprise Manager. Open SQL Server Enterprise Manager, expand the database under SQL Server Group local, right-click the database you want to back up, select the backup database under All Tasks in the pop-up menu, and eject the Backup Database dialog box:
Click the Add button, fill in the path and file name of the backup file, click OK to add the backup file, click the Backup dialog box, and start the backup.
Second, through the Enterprise Manager multiple data Timing Library backup. Open SQL Server Enterprise Manager, expand the Management node under the SQL Server group, right-click the database Maintenance plan, and select a new maintenance plan. In the Welcome dialog box that pops up, select Next, and then the following dialog box appears:
Select the database you want to back up, and the next step. In the next step, we default all options, next. In the current dialog box you can choose whether to check the integrity of the database, where we can do the next step by default. The dialog box is shown in the diagram:
Select to back up the database as part of the maintenance plan, click the Change button to modify the time to back up the database, click Next, and then enter the following figure:
Here, we can choose "Use this directory" to specify a path for backup, select "Delete files older than this time" to specify the retention time of the backup file.
The following steps we all choose the default setting, and finally a name for the backup in the completion dialog, and when clicked, the database is backed up at the time you specify. For more information on database maintenance plans, check out other relevant data.
Third, back up the database files. Open SQL Server Enterprise Manager, expand the database under SQL Server Group local, right-click the database you want to back up, and select Properties. Select the data file in the pop-up dialog box, showing the path to the data file, as shown in the following figure:
Open SQL Server Service Manager and stop SQL Server. Then open My Computer, find the data file path, copy it out for backup (note the simultaneous backup.) LDF file).
Finally, turn on the SQL Server service
Iv. replying to the database backup file (for databases backed up with Enterprise Manager). Open SQL Server Enterprise Manager, expand the database under SQL Server Group local, right-click the database you want to restore, select the Restore database under All Tasks, and pop up the following dialog box:
Select from device, click Select Device, add backup file path for restore, and then make a definite restore.
Five, restore the database backup files. Right-click the database node in Enterprise Manager, select an additional database under All tasks, and eject the Additional Database dialog box. The following figure:
Select a data file that you copied before and click OK to append success (note: If the database already exists, delete the database and append it).
