Submit a ticketCall us

Quickly Address Software Vulnerabilities
Patch Manager is an intuitive patch management software which extends the capabilities of WSUS and SCCM to not only patch Windows® servers and workstations, and Microsoft® applications, but also other 3rd-party applications which are commonly exploited by hackers. Learn more about our patch management solution.

 

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 Rodim Suarez on Sep 12, 2016

Views: 874 Votes: 6 Revisions: 12

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.

 

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
16:48, 12 Sep 2016

Tags

Classifications

Public