Submit a ticketCall us

Announcing NPM 12.2
With NPM 12.2 you can monitor your Cisco ASA firewalls, to monitor VPN tunnels for basic visibility and troubleshooting tunnels. NPM 12.2 also uses the SolarWinds Orion Installer so you can easily install and upgrade one or more Orion Platform products simultaneously.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Backup the database using SQL Server Management Studio

Backup the database using SQL Server Management Studio

Table of contents

Updated July 21st, 2016

Overview

How to backup DB using SQL server management Studio

Environment

SQL server all versions

Detail

To back up a database

  1. After connecting 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 depending on the database, either select a user database or expand System Databases and select a system database.
  3. Right-click the database, point to Tasks, and then click Back Up. The Back Up Database dialog box appears.
  4. In the Database list box, verify the database name. You can optionally select a different database from the list.
  5. You can perform a database backup for any recovery model (FULL, BULK_LOGGED, or SIMPLE).
  6. In the Backup type list box, select Full.
  7. Note that after creating a full database backup, you can create a differential database backup; for more information, see Create a Differential Database Backup (SQL Server).
  8. Optionally, you can select Copy Only Backup to create a copy-only backup. A copy-only backup is a SQL Server backup that is independent of the sequence of conventional SQL Server backups. For more information, see Copy-Only Backups (SQL Server).
  9. When the Differential option is selected, you cannot create a copy-only backup.
  10. For Backup component, click Database.
  11. Either accept the default backup set name suggested in the Name text box, or enter a different name for the backup set.
  12. Optionally, in the Description text box, enter a description of the backup set.
  13. Choose the type of backup destination by clicking Disk, Tape or URL. To select the paths of up to 64 disk or tape drives containing a single media set, click Add. The selected paths are displayed in the Backup to list box.

 

 

Last modified
13:52, 16 Jan 2017

Tags

Classifications

Public