You also cannot back up, detach, or otherwise move the snapshot files.
You remove snapshots by using the DROP DATABASE command:
DROP DATABASE AdventureWorks_SS
Take care in removing snapshots, particularly if your naming convention doesn??™t
include some indication that what you are removing is in fact a snapshot. The risk is
that you will write a DROP DATABASE command and then unthinkingly follow that command
with the name of a database, and not of a snapshot. You won??™t be able to drop the
source database of a snapshot, but it is possible to type in the wrong database name.
Since T-SQL commands execute without a confirmation prompt, you could be initiating
a disaster scenario! That would qualify as a process error.
Restoring Database Snapshots
I generally prefer the phrases ???reverting to a snapshot??? or ???snapping back,??? but technically,
you??™re restoring the database from the snapshot files. The command to restore a
database snapshot is probably too simple:
RESTORE DATABASE AdventureWorks FROM DATABASE_SNAPSHOT=AdventureWorks_SS
The great thing about restoring is that it returns the database to that point in time
immediately.
Pages:
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430