Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

Home > Success Center > Network Performance Monitor (NPM) > Backup and restore SQL database instance using a .BAK file

Backup and restore SQL database instance using a .BAK file

Table of contents
Created by Milton Harris, last modified by Andy Ng on Jul 26, 2017

Views: 3,347 Votes: 8 Revisions: 14

Overview

How to backup and restore SQL database instance using a .BAK file.

Environment

All NPM versions

Detail

Here is an 8 minute 21 second video (taken from the Solarwinds Inc Youtube channel) that shows you how to backup and create a *.BAK file for backup.

 

 

Once you have the BAK file moved over to your new SQL box, you can just restore from the BAK file and name it the same database instance name as you had on the old SQL 

 

To backup a BAK file:

  1. Open up SQL Studio Manager.
  2. Select the database instance name you want to backup in the left navigation pane.
  3. Right click > tasks > backup.
  4. For Destination, select: Disk.
  5. Type of file shown should be a file with the extension *.BAK.

 

To restore from a BAK file: 

You can refer to the Restore a Database Backup Using SSMS Microsoft article for reference: 

  1. Open SQL Server Management Studio in Object Explorer, rght click on Databases Node and select Restore Database.
  2. The Restore Database dialog box will be displayed on the General page.
    a. The name of the restoring database appears in the To database list box. To create a new database, enter its name in the list box.
    b. Select ‘From device’.
    c. Click the button to display ‘Specify Backup’ Dialog.
    d. Click ‘Add’  to browse the .bak file from the directory and click OK.

     
  3. Click on "Files" tab, and ensure that the "Restore As" column do not already have the files with the same file name or the restore will fail; ensure that all the files are unique:
  4. In the above example, the Data file is stored in D:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SolarWindsOrion.mdf
    ** Ensure that the file does not exist on the SQL server in the exact same path; workaround - you will have to rename the file or change it's path

 

There are a few assumptions we make when attempting to output the bak file and restore it: 

  • You must have DBOwner rights to be able to restore the BAK file, otherwise if you try to import the BAK file back in you will get an error.
  • Please try to use a 'sa' or sa-equivalent account when attempting to back up and restore to achieve the best results.
  • While it is possible to backup the database using an alternative method (other than creating a BAK file), like by restoring from raw MDF and LDF files, for example, you must be particular about which accounts you use to do so, again using an Administrator like account with all rights will achieve the highest chance for success, feel free to use another account but you may not achieve the same rate of success

 

Note: Solarwinds Support is not responsible for supporting the BAK file itself. If Microsoft tools are used to create the BAK file extension then Microsoft Support is responsible for supporting the BAK file itself should the BAK file itself become corrupted.

 

 

Last modified
22:34, 25 Jul 2017

Tags

Classifications

Public