Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Feedback

Backing Up a Database


Overview

This article details the required steps to create a full backup of a database using SQL Server Management Studio.

Process

To Back Up a Database

1. Connect to the appropriate instance of the Microsoft SQL Server Database Engine, in Object Explorer, click the server name to expand the server tree.


2. Expand Databases, and select the database on which to perform a backup. In this example we will select the AdventureWorks Database


3. Right-click the database → point to Tasks → click Back Up... The Back Up Database dialog box appears.


4. In the Database list box, verify the database name and set the Backup type to Full.


5. For Backup component, click Database.

6. Choose the type of backup destination by clicking Disk or Tape . The selected paths are displayed in the Back up to list box.

7. Either accept the default backup location, or click Add.. to choose another location.

Tape will be grayed out if not applicable.

To remove a backup destination, select it and click Remove . To view the contents of a backup destination, select it and click Contents .
8. Click OK.


Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments