3 4
Chapter 9
This chapter prepares you to perform each type of SQL Server 2000 database backup and restore. First, you learn about backup terms, media, and devices. Next, you learn to perform each type of database backup, using SQL Server Enterprise Manager and Transact-SQL. You then learn to restore databases and database files using SQL Server Enterprise Manager and Transact-SQL. Finally, you learn how to restore or rebuild system databases. After you have completed these tasks, you will be ready to apply database security and place your SQL Server 2000 databases into production.
To complete this chapter, you must have