Summary
In this chapter we covered the concepts of restoring and recovering data. There are various methods for restoring that are based on the type of backups that are taken. Data can be restored to any point in time or to the point of failure if backups are taken properly. Therefore, the strategy chosen for backup and restore is extremely important for protecting critical business data. Documenting restore procedures and putting them in a known location that the appropriate people can access is also very important.
There were several features mentioned in this chapter that are available only with SQL Server 2005 Enterprise Edition: online restores, fast recovery, and database snapshots. Be careful when choosing your edition to make sure you get ...
Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
