Table 3-4. Relevant Information in the MSDB restorehistory Table
Column Contents
Restore_Date The datetime of the start of the restore operation.
Restore_Database_Name The name of the destination database. If the WITH MOVE clause is
included, this may not be the same as the original database name.
User_Name The user, as it is known in SQL Server, who executed the RESTORE
command. If the user was authenticated via a Windows group, the
Windows group will be displayed.
Restore_Type This can be a database (D), a file (F), a filegroup (G), a differential (I),
VERIFYONLY, or a revert (R), which applies to a database snapshot (more
on database snapshots in Chapter 9).
Replace A 1 indicates that existing files were replaced with the WITH REPLACE
option??”the equivalent of the ???Overwrite existing files??? option in the
GUI.
Recovery A 1 indicates that the WITH RECOVERY clause was included. Remember,
this is the default behavior as well.
Restart A 1 indicates that this particular RESTORE command is associated with a
previous backup that failed and was repeated with the RESTART
command.
Pages:
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140