Summary

3 4

This chapter completes our examination of database backup, restore, and recovery operations. In this chapter and the last chapter, you've learned how to effectively back up and restore a system and how SQL Server recovery works. You've seen how to perform these operations by using both Enterprise Manager and TSQL commands. This chapter focused on restore operations and on preparing a disaster recovery plan, a critical job. Remember, the security of the system is a major responsibility of the DBA.



Microsoft SQL Server 2000 Administrator's Companion
Microsoft SQL Server 2000 Administrators Companion
ISBN: B001HC0RPI
EAN: N/A
Year: 2005
Pages: 264

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net