Contents
Display Legacy Contents

Home > Server Backup > Microsoft SQL  > Backup

Backup


Backup MS SQL Server database files without interfering with the already running MS SQL Server services.

To backup MS SQL Server,

  1. Login to the IBackup application and click the Server Backup tab.
  2. Under MS SQL Server section, click Backup.



  3. Provide the relevant authentication information when prompted. IBackup provides two modes of MS SQL Server authentication. You can connect to your database using:

    a. Windows Authentication Mode:  When you connect through a Windows user account, SQL Server validates the account name and password using the Windows principal token in the operating system. This means that your identity is confirmed by Windows. SQL Server does not ask for the password and does not perform the identity validation. Windows Authentication is the default authentication mode, and is more secure than SQL Server Authentication. 

    b. SQL Server Authentication Mode: When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows user accounts. Both the user name and the password are created by using SQL Server and stored in SQL Server. While connecting using SQL Server Authentication, you must provide your credentials (login and password) every time. When using SQL Server Authentication, you should set strong passwords for all SQL Server accounts.



    Note    : If you attempt to connect to an instance of MS SQL Server by providing a blank login name, the SQL Server uses the Windows Authentication. Additionally, if you connect to an instance of SQL Server configured for Windows Authentication Mode using a specific login, the login is ignored and the Windows Authentication is used.

  4. Select the database(s) from the list displayed and specify the temporary local backup path.
  5. Select Online Backup or Local Backup radio button, and click Schedule Now.



  6. The Schedule backup screen is displayed where you can schedule the backup for any future day and time or perform an immediate backup of the selected databases.

Note: IBackup 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 followed by the instance name scheduled for backup.

Example: If the instance name is MJOHN\INSTMJOHN then the name of the backup job is IBSQLServerBkset (MJOHN##INSTMJOHN).