SQL Server 2008 BACKUP Database

1. Open SQL, locate the database you want to back up, right-click >> tasks >> Backup

2. Popup [Backup Database dialog],:

3. Click Add [Button]. Such as:

4. Select the path to be backed up and the file name of the backup click [OK].

5. Then just click OK to do it. Then we came to D:\. Look

6. At this time, you can compress it to pack something, to use the time, after the file Add. bak suffix can be restored with SQL, restore can see here ~

SQL Server 2008 BACKUP Database