One of the most useful and potentially problematic features of SQL Server is the database snapshot. It provides two basic pieces of functionality: 1) a point-in-time view of a database (a data time machine, if you will) and 2) the ability to restore the production database to that point in time extremely quickly. However, a database snapshot is not part of, nor should it ever be a part of, a backup/recovery process. It needs a live database in order to function. It can play an important role in a disaster recovery plan, though.
KeywordsNaming Convention Disaster Recovery Source Database User Error Data Page
Unable to display preview. Download preview PDF.