Databases Reference
In-Depth Information
The
Restore
command reads all the files from a backup file that you specify. It places
them into their target locations and, at the end of the transaction, renames the files. If
you plan to overwrite your existing database, you will nevertheless see new files appear in
the same folders as the existing data files. Your existing files won't be overwritten until the
operation has been committed. Therefore, make sure that you have enough storage room
for both sets of files.
The primary design goal of the restore operation is to provide a rich set of functionality
and to enable you to custom configure your restored database. The restore operation has
quite a number of options, according to the various physical layouts of data files.
Using the Restore Database Dialog Box
The Restore Database dialog box is a perfect training tool if you're performing an Analysis
Services restore operation for the first time, or if you prefer the ease and convenience of
the user interface. Here's how you can use the Restore Database dialog box: Start in SQL
Server Management Studio and right-click the Databases folder. Choose Restore from the
contextual menu. Figure 39.5 shows what you would see.
The options in this dialog box are arranged in three categories:
.
The Restore Target category, where you choose the database you need to restore from
the drop-down list in the Restore Database text box. If you want to keep your
damaged database alongside the restored one, just type a different name for the
restored database. In addition, you supply the name of the backup file you want to
use in the From Backup File text box.
.
In the Options category, you have two choices to make:
.
Select the Allow Database Overwrite box if you want your newly restored data-
base to replace the damaged one. If you don't want the restored database to
overwrite the old one, you must give the restored database a different name.
.
Select the Include Security Information box if you want to skip restoring
membership information for Analysis Server security roles.
.
Fill in the Encryption category if the database backup file you are restoring this data-
base from was encrypted when it was created. In such a case, in the Password text
box, enter the password that was set for the backup file when it was created.
Search WWH ::
Custom Search