SEARCH
0-9 A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Prev | Current Page 187 | Next

James Luetkehoelter

"Pro SQL Server Disaster Recovery"

bak'
WITH NORECOVERY
-- I prefer to do recovery as a separate step
RESTORE DATABASE AWSample
WITH RECOVERY
This example shows a basic filegroup recovery. Sometimes you may want to restore
a single filegroup, but in most cases, you??™ll want to restore the entire database one piece
at a time.
Performing Partial Backups and Restores
Although it does deal with filegroup backups, a partial backup is really more like a full
backup. You perform a partial backup by specifying the keyword READ_WRITE_FILEGROUPS
in your BACKUP DATABASE command:
BACKUP DATABASE Adventureworks
READ_WRITE_FILEGROUPS TO
DISK='C:\AWPartial.bak'
What??™s the point of a partial backup? Well, if you have filegroups that are read-only,
they really only need to be backed up once, don??™t they? Plus, you don??™t really need to use
the BACKUP DATABASE command to back them up??”you could just stop SQL Server at some
point and perform a file-based backup on those read-only files.
Let??™s say you have two tables: an Order table and an OrderHistory table. Order is 80MB
in size, with another 70MB of nonclustered indexes on it.


Pages:
175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199
druga wojna światowa Free English grammar and study guid hotel jelenia góra Russian bride counter strike 1.6