Stop_At The point in time where the database was stopped.
Stop_At_Mark_Name The log mark name, if that technique was used, where the restore
stopped.
Stop_Before 1 indicates that it includes the transaction associated with the
Stop_At_Mark_Name value, while 0 indicates that this transaction was not
included in the restore.
CHAPTER 3 n RESTORING A DATABASE 52
This table is useful for diagnosing failed restore attempts (which I often end up dealing
with). As long as the RESTORE command was used, a row exists.
The restorefilegroup and restorefile tables contain basic information regarding file
and filegroup restores. I??™ll revisit them in Chapter 4.
Restoring Full Backups
With the exception of database snapshots, which I??™ll be discussing at length in Chapter 9,
all restore operations start with the restore of a full backup. It isn??™t possible to restore only
a differential or a log backup. Both need a point of reference??”the LSN??”to proceed.
Restoring in Simple Recovery Mode
This is the most basic restore scenario. While I do believe there can be a place for Simple
Recovery mode for a production database (an argument I??™ll expand upon in Chapter 5),
you??™re unlikely to face it for a production database.
Pages:
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141