On-Premises DNN Database Backup

Overview

Database backup is a common maintenance task. It is highly recommended as a part of general disaster recovery strategy and before any kind of significant production changes. The process may vary slightly depending on the version of the database engine. The steps below will represent backup file creation using SQL Server Management Studio Express.

We will create a backup file for the database named “backmeup” to the “C:\backup” folder as an example.

 

Step-By-Step Guide

  1. Run SQL Server Management Studio.
  2. Connect to your DNN database.
  3. Locate your DNN database in the Explorer window at the left.
  4. Right-click on your database.
  5. Click Tasks.
  6. Click Back Up...
    kb-sql-backup-mgmt-studio-1.jpg
  7. Select Full in the Type List Box.
  8. Click on the default backup path under Destination section.
  9. Click Remove button.
    kb-sql-backup-mgmt-studio-2.jpg
  10. Click Add Button.
    kb-sql-backup-mgmt-studio-3-300x268.jpg
  11. Input location of your choice which will be used to save backup file (e. g. “C:\Backup\backmeup-Full-041608.bak“). Keep in mind that this will be an entire file path with a file name.
  12. Press OK button.
  13. Press OK to proceed to the next window.
  14. Click Overwrite all existing backup sets radio button. This will help to avoid conflicts while performing a restore as opposed to appending to the existing data set.
    kb-sql-backup-mgmt-studio-5.jpg
  15. Press OK button to proceed to the next window.
  16. Verify the file path in the Select Backup Destination window.
  17. Press OK to start the backup process.
    kb-sql-backup-mgmt-studio-4.gif
  18. Press OK button once backup process will be completed successfully.
    kb-sql-backup-mgmt-studio-7.jpg

 

Confirmation: Verify that the file with the specified name and under the specified path has been created. In our case, it is C:\Backup\backmeup-Full-041608.bak.

Comments

0 comments

Please sign in to leave a comment.