Welcome to Lesson 4 of the SQL Server 2000 Tutorial. In this lesson we will cover backing up a database. I hope you enjoy the lesson.
Backing up Databases
Backing Up A
Database
Backups are the number one priority of a Database
Administrator. There is nothing more important than valid
backups. You can do a backup from Enterprise Manager or
Query Analyzer. The easiest way is to use Enterprise Manager.
We will do a backup of the Northwind database for
this tutorial. Open up Enterprise Manager and select the
Northwind database, then click on the wizard button.
Expand the Management tree, and select Backup
Wizard. Click OK button.
Welcome screen appears, Click Next.
Select Northwind, and click Next.
Leave the default name and click Next.
Select Database Backup and click Next.
Leave the default and click Next.
Leave default and click Next.
Click Finish
Show the progress of the backup.
Displays message when backup is complete.
