I completed a database restore that appeared to be successful. The object here was to restore a bak file from a remote database server to a newly created database on the local server. However, when I was doing a follow-up check, I noticed there was a file size discrepancy between the bak file that was used for the restore, and the size of primary data file.
When the restore was done, I utilized Management Studio, and ran through the steps listed below:
1. Open SQL Server Studio, and select Databases from the left pane.
2. Right-click on Databases, and select Restore Database from the drop down menu.
3. Click on the From device radio button in the Source for restore section.
4. Click on the button at the far right of the field, and the specify backup window will
appear on-screen. Make sure the Backup Media type shown in the field is File.
5. Click on the Add button, and navigate to the location of the desired backup file. The
file in this example is:
and is located at G:\BACKUP\Full Backups.
6. Type in the name of the database in the To Database field in the Destination for restore
section. Typing in a name that is different from the currently listed databases will
cause SQL Server to create a new database during the restoration process. The name of
the new database in this procedure is: <database>_AK.
7. Click on the Options icon in the left panel to bring up the next page.
8. Go to the Restore As field for the various parts of the database , and by right clicking
on the button at the far right for each part, change the location of the restored files.
The Rows Data, mdf, file should be restored here:
The Log, ldf, file should be restored here:
The Filestream Data should be restored here:
The location of the bak files is an iSCSI volume that is mounted by the local server. The volume is an export from a remote server where the bak file is located. The bak file is the latest in a series of image backups that have been run which create bak files bigger than the previous ones.
How can I verify the database restoration is truly successful?