How to create a backup of the SQL Server database in Microsoft SQL Server 2005 and in Microsoft SQL Server 2000


INTRODUCTION


This article discusses how to create a backup of the Microsoft SQL Server database.

More Information


If you are running SQL Server 2005 use Method 1. If you are running SQL Server 2000 use Method 2.

Method 1

  1. Log in to SQL Server Management Studio.
  2. In the Object Explorer pane, expand the appropriate instance of SQL Server.
  3. Expand Databases.
  4. Right-click the appropriate database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
  5. Under Destination, click Add. The Select Backup Destination dialog box appears.
  6. In the File name box, type the path and file name.

    Note The file name must have a .bak extension.
  7. Click OK, and then click OK.

    Note When the backup process finishes, you receive a message that resembles the following message:
    The backup of database 'Test' completed successfully.

Method 2

  1. Log in to SQL Server Enterprise Manager.
  2. Expand Microsoft SQL Servers, expand SQL Server Group, expand the appropriate server, and then expand Databases.
  3. Right-click the appropriate database, point to All Tasks, and then click Backup Database.
  4. Under Backup, click Database - complete.
  5. Click Add. The Select Backup Destination dialog box appears.
  6. In the File name box, type the path and file name.

    Note The file name must have a .bak extension.
  7. Click OK, and then click OK.