Database Reference
In-Depth Information
Figure 5-39.
Saving your SQL script files to the new
DWPubsSales
folder
create a Database Backup
now that you have the backup and restore script, you need to use it to back up your database.
1.
Execute the
BACKUP DATABASE
statement to create a database backup file in the
DWPubsSales
folder. To do this, highlight the
BACKUP DATABASE
statement in
the Query Window, as shown in Figure
5-40
, and click the “! Execute” button.