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

Work anywhere from any device with Microsoft 365

Upgrade to Microsoft 365 to work anywhere with the latest features and updates.

Upgrade now

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×