Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

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


How to backup DB using SQL server management Studio


SQL server all versions


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