On-Premise DNN Database Backup

Overview

Database backup is a common maintenance task. It is highly recommended as a part of the general disaster recovery strategy and before any kind of significant production change. 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.

 

Prerequisites

  • Access to SQL Server and SQL Management Studio
  • Access to the DNN file structure

 

Solution

  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...
    2020-06-11_1647.png
  7. Select Full in the Type List Box.
  8. Click on the default backup path under Destination section.
  9. Click Remove button to remove the default/last backup file name.
    2020-06-11_1649.png
  10. Click Add Button.
  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. Verify the file path in the Select Backup Destination window.
    2020-06-11_1653.png
  13. Click on Media Options.
  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.
    2020-06-11_1652.png
  15. Press OK button once backup process will be completed successfully.
    2020-06-11_1654.png

 

Testing

Verify that the file with the specified name and under the specified path has been created. The SQL backup should end with a .bak

Comments

0 comments

Please sign in to leave a comment.