![]() You will then have the options to save this backup and schedule as an XML Backup Definition File. Once you are happy with your backup configuration, select ‘Finish’. Once you have selected your schedule and retention rules, select ‘Next’ to review what will be included in the backup. You can then define a schedule and the retention rules for this backup: Once you have selected the databases that you want to include, and the destination for where the SQL backups will be stored, select ‘Next’. This will present you with a list of the available SQL databases that you can backup. To do this, select ‘Backup SQL Database’. Now that Macrium Reflect can access the SQL Database, you can start taking your backups. You can choose from either ‘Windows Authentication’ or ‘SQL Server Authentication’. This will open a window where you can enter the authentication details for that instance. If necessary, you can manually connect to these SQL instances by selecting the SQL instance and then ‘Connect’. Macrium Reflect will enumerate the available SQL instances and display them. Granular backup is achieved by first selecting ‘Manage SQL Logins’ under the ‘SQL Server Tasks’ on the ‘Backup’ page. The latter will allow for granular backup, restore and to point in time. The former will include all databases on selected volumes and not allow for granular backup and restore. To create a backup of your MS SQL Database you can create an image of the volumes that contain SQL Databases or use the ‘Backup SQL Databases’ option. ![]() This includes the ability to backup and restore individual databases. Macrium Reflect Server Plus includes several features that are useful when backing up data that is stored in a MS SQL Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |