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

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

INTRODUCTION

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.

More Information

Meer hulp nodig?

Uw vaardigheden uitbreiden
Training verkennen
Als eerste nieuwe functies krijgen
Deelnemen aan Microsoft insiders

Was deze informatie nuttig?

Wat heeft uw ervaring beïnvloed?

Hebt u aanvullende feedback? (Optioneel)

Bedankt voor uw feedback.

×