Beginning Backup and Restore for SQL Server by Bradley Beard

Author:Bradley Beard
Language: eng
Format: epub, pdf
Publisher: Apress, Berkeley, CA

Size: The size of the backup.

Username: The username of the account used to generate the backup.

You will use these columns to determine exactly which backups to restore and the order in which to restore them. Luckily, SSMS makes this easy for you.

Scroll down to the bottom of the Select the backup sets to restore: area. The last item listed in this area should be a transaction log backup. If a transaction log isn’t listed last, then move up the list, or earlier in time, to the last transaction log backup. Check the Restore check box and notice that all the other transaction logs since the last differential backup become selected, along with the last differential backup. This is because SQL Server is aware that it needs to restore a full backup first, then the differential backup, and then the transaction logs, in the correct time order, in order to successfully restore the database to the point in time. You should see something similar to what is shown in Figure 7-5 at this point.

Figure 7-5Last transaction log selected

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.