bak"
WITH NORECOVERY
RESTORE LOG AdventureWorks
FROM DISK='D:\SQLBackups\AWLog2.bak'
WITH RECOVERY, STOPATMARK LSN:2433:5422
Log Marks
You can create log marks before performing a transaction that allows you to restore
directly up to the point where the log mark was created. The following example shows a
transaction called LogMarkAfterUpdate that contains a log mark:
CHAPTER 3 n RESTORING A DATABASE 61
RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWFull.bak'
WITH NORECOVERY -- We aren't done with our Restore process
RESTORE LOG AdventureWorks
FROM DISK='D:\SQLBackups\AWLog1.bak"
WITH NORECOVERY
RESTORE LOG AdventureWorks
FROM DISK='D:\SQLBackups\AWLog2.bak'
WITH RECOVERY, STOPATMARK 'LogMarkAfterUpdate'
With both LSN and log-mark restores, you can specify STOPBEFOREMARK and
STOPAFTERMARK. As you??™ll see in Chapter 5, the difference between those two options can
be significant.
Mirroring Backups
In Chapter 2, you learned that SQL Server 2005 and higher supports mirrored backups.
While mirroring full backups doesn??™t seem like an efficient use of I/O or disk space, mirroring
transaction log backups should be a given (assuming that they??™re being written to
different locations).
Pages:
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152