KnowledgeBase
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

With Macrium Reflect Server Plus you can backup SQL databases. All versions of Microsoft SQL Server and Microsoft Server Express are supported from SQL Server 2005 onwards. SQL Server 2000 and earlier are not supported.
 

  1. Select Manage SQL Logins.



    Macrium Reflect scans your local PC for installed instances of SQL Server and displays them:



    If no instances are displayed, this could be because the SQL Browser service has been disabled. Please see this knowlegdebase article for more information. 
     
  2. If necessary, to enter details manually, select Connect to SQL instance manually.

  3. Select the instance you wish to connect to and click Connect.
     
  4. Enter the required login criteria and click Connect.



    If successful, the instance shows as Connected.
     
  5. Select Backup SQL Databases:



    This displays all the databases associated with the instances of SQL that you have logged into.
     
  6. Select the databases you wish to backup.
     
  7. Set the destination directory for the image files (in this case E:\ drive) and if necessary any alternative locations.

  8. If required, add new instances or refresh the list as required. Click Next. 

  9. If required, click Advanced Options to modify aspects of the backup such as Compression, Encryption, Disk Space Management Configuration, Shutdown options and email notification settings. When you are happy to proceed, click Finish.
     
  10. Just as in normal imaging, you are offered the ability to save your configuration as an XML definition file for later reuse. Click OK to run the backup.

How to create differential and log backups

To create a differential or log backup, it is important to ensure that you have already created an SQL XML definition file and run a full backup. Please note that it is not possible to create Log backups of database which use the SIMPLE recovery model.

To create a log or differential backup:
  1. Go to the Backup Definition Files tab under the Backup tab and select the XML file you wish to perform an log or differential backup of.
  2. Select the Run option or right-click on the XML file you wish to run



    Select the type of backup you wish to run.
  3. The backup should be run immediately.
  • No labels