Attix5 Pro FAQ
Search:     Advanced search

Backing up and restoring detached SQL Server databases using file-level selections (with ESE)

Article ID: 314
Last updated: 14 Jul, 2015

SQL Server databases can be backed up using the file selection from the Files view or database selection from the SQL view in the Backup Selection tab.

Note: Typically during a disaster recovery, to restore the 'master' database previously backed up from the SQL view, proceed to the Restore section below.

    

The recommended method to back up SQL databases with ESE is to use VSS i.e. from the SQL view. This will automatically include all the metadata associated with the databases (e.g. file location, permissions). But in the event that a database is detached, the VSS SQL backup will skip the database, even though the files still exist on disk.

Warning: Offline databases still attached to the SQL Server instance will not be backed up.

To back up

To safeguard detached databases from not being backed up, database files can also be backed up seperately:

Note: This is not the recommended method because the database's meta data is not backed up. The ESE backup log will indicate that backing up using the SQL view is best.

  1. Browse to and manually select the files (*.mdf, *.ldf) in the Files view.
  2. Start the backup as per normal.

Database files will be backed up and/or patched if there were any changes since the last VSS backup performed from the SQL view.

To restore

If a restore of that specific backup is required, it will not be available via the SQL view but can still be restored on a file level:

  1. Browse to and select the files in the Files view - this time under the Restore tab.
  2. Once the database files are restored:

Article ID: 314
Last updated: 14 Jul, 2015
Revision: 15
Views: 1384
Comments: 0
Posted: 12 Jun, 2015 by Van Rensburg J.
Updated: 14 Jul, 2015 by Du Plessis S.
This article was:  
Prev   Next
Article 313 - How to restore the AccountServer database after a new install     Article 316 - Understanding Attix5 Pro Snapshot Import Behaviour on the...