Chapter 9 -- Backing Up Databases

[Previous] [Next]

Chapter 9

About This Chapter

In this chapter, you will learn about the media that you can use when creating Microsoft SQL Server backups and how to perform backups using SQL Server Enterprise Manager or the Transact-SQL BACKUP statement.

Before You Begin

To complete the lessons in this chapter, you must have

• Installed SQL Server 7 on your computer. Installation procedures are covered in Chapter 2. The exercises assume that you are working on a Microsoft Windows NT Server configured as a domain controller, although you can complete the exercises using SQL Server installed on Windows NT Workstation or on a standalone Windows NT Server. You can also complete all of the exercises for this chapter on SQL Server installed on Microsoft Windows 95 or Windows 98.
• Installed the StudyNwind database.
• Created the StudyNwind database. If you have not done this, run the Maknwind.cmd batch file in the Exercise\Setup folder.
• Experience using the SQL Server Enterprise Manager and SQL Server Query Analyzer.