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

  • Article

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

Applies to:   Microsoft Dynamics SL
Original KB number:   867941

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

Method 1

  1. Sign 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 select Back Up. The Back Up Database dialog box appears.

  5. Under Destination, select 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. Select OK, and then select 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. Sign 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 select Backup Database.

  4. Under Backup, select Database - complete.

  5. Select 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. Select OK, and then select OK.