Backup Microsoft SQL Server

IBackup for Windows now has the ability to execute online backup of MS SQL Server Databases without interrupting running services. It is fast, secure and reliable. Following are the steps to backup your MS SQL Server using IBackup for Windows.

Step 1. Choose the SQL Server Backup option in the following ways by going to the main menu and opting for the option: Backup-Restore >SQL Server > SQL Server Backup

Or alternately by opting for the option under the main toolbar: Wizards > Advanced Backup > SQL Server > SQL Server Backup.

Step 2. Provide the relevant authentication information when prompted. IBackup for windows provides two modes of MS SQL Server authentication

Step 3. Select one or more databases from the list of databases displayed.

Step 4. Choose the destination directory in your IBackup account where the backed up database files (*.dmp) will be stored.

Step 5. You will be taken to scheduler wizard screens, using which you may schedule the backup for any future date and time with various backup options or perform a immediate backup of the selected databases to your IBackup account.

Note : IBackup for Windows allows you to schedule the SQL Server backup for different instances. For easy identification of the SQL Server Backup set, the name of the Backup set will be 'IBSQLServerBkset' and followed by the instance name that you have scheduled for backup.

For example: If the instance name is 'MJOHN\INSTMJOHN' then the name of the backup job will be 'IBSQLServerBkset (MJOHN##INSTMJOHN)'