Page History

1. Select Manage SQL Logins.
    Image Removed
   Image Added
   
   Macrium Reflect scans your local PC for installed instances of SQL Server and displays them:
   

    Image Removed

   
   Image Added
   
   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.
    Image Removed
   Image Added
   
   If successful, the instance shows as Connected.
    
5. Select Backup SQL Databases:
   Image Removed
   Image Added
   
   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 andrefresh or refresh the list as required.  Click Next.
   

9. Make required edits to the backup plan, for more information see Scheduling backups.

   Image Removed

10.  
    
    
11. If required, click Advanced Options to modify aspects of the backup ; such as Compression, File Size, Password, Auto Verify Image, Comments, Reparse Points  and ShutdownEncryption, Disk Space Management Configuration, Shutdown options and email notification settings. When you are happy to proceed, click OkFinish.
     
12. Click Finish.
13. Just as in normal imaging, you are offered the ability to save your configuration as an XML definition file for later reuse. Name the backup and click 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. Note: It Please note that it is not possible to create log Log backups of database using which use the Simple SIMPLE recovery model.

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.
   Image Removed
   Image Added
   
   Select the type of backup you wish to run.
3. The backup should be run immediately.