Chapter 9 -- Backing Up and Restoring SQL Server

3 4

Chapter 9

About This Chapter

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.

Before You Begin

To complete this chapter, you must have

  • A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1 "Hardware Requirements," in the Lesson 1 section of Chapter 2.
  • Microsoft Windows 2000 Server running on your computer on an NTFS partition.
  • A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain .
  • Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).
  • Created the SSEMDB database using the CreateDB.sql script (see Chapter 6).


MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
ISBN: N/A
EAN: N/A
Year: 2001
Pages: 126

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