If, for some reason, you create a full backup out of your normal backup scheme (to move to a
development platform, for example), you can accidentally nullify the usefulness of including differential backups.
I have personally experienced this frustration under SQL Server 2000 and 7.0 on multiple occasions.
From this point forward, any ???extra??? full backup I make will include the WITH COPY_ONLY clause.
Restoring to a Point in Time
You can use three methods to restore the database to a specific point in time. First, you
can obviously specify a specific time. Second, you can jump to the exact LSN number you
want to restore to if you remember it (remember all those LSN entries when you ran a
RESTORE HEADERONLY?). Third, you can create and specify named log marks, and then you
can restore to one of those marks. Regardless of which option you chose, you can choose
whether the restore should include the stopping point, or whether the restore should go
up to, but not including, the stopping point. (For example, you can choose to restore up
to and including a given LSN, or up to but not including the LSN.
Pages:
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149