Database Reference
In-Depth Information
Figure 5-41.
Executing the
RESTORE DATABASE
statement
create a Database Script File
You now have a tested backup and restore script as well as a database backup file in the
DWPubsSales
folder. Let's add a complete script for creating the database. We have created a custom script for this
process, so you just need to review the code and add it to the folder.
1.
open the author's version of the script file and review its contents. To do this, use
the File ➤ open ➤ File menu in SQL Server Management Studio and open the file
C:\_BookFiles\Chapter05Files\Create DWPubsSales Script.sql
.
2.
Review the contents of the file and then save it to the
DWPubsSales
folder. To do
so use SQL Server Management Studio and click the File ➤ Save ➤ current file
name ➤ As . . . menu item.
