Section 18 - Backup / Restore Microsoft SQL Server

This section describes how to backup and restore Microsoft SQL Server with the OBM.

18.4 How to backup Microsoft SQL Server database

Refer to the following instructions to backup Microsoft SQL Server database:




• Login to the backup application's user interface.



Double-click on the OBM desktop icon or right-click on the system tray icon:






• Select the [Backup Settings] button and the button to start the New Backup Set Wizard.
• Create a MS SQL Server Backup set by selecting [MS SQL Server Backup] from the backup set type dropdown menu.




• Enter the corresponding information required:






Menu Items	Description
Name	Enter a backup set name of your choice.
Type	Select backup set type [MS SQL Server Backup].
Server	Select the server instance to be backed up.
Login ID	Enter the Login ID of the MS SQL administrator account. (Only for SQL Server database set to SQL Server and Windows Authentication mode)
Password	Enter the password of the MS SQL administrator account. (Only for SQL Server database set to SQL Server and Windows Authentication mode)



• Select [Next] to proceed.
• Select the corresponding database for backup.




• Configure a backup schedule for unattended backups.



Note:
Multiple backup schedules of different types can be configured for the same backup set.




• Select an encryption setting for your backup set.
• Press the [OK] button to complete the configuration of backup set.




For SQL Server database with Windows Authentication mode:



• Configure the [User Authentication for Windows] setting.
• Enter the login credentials of a Windows account with sufficient permission to access the MS SQL databases server.






Menu Items	Description
Domain	SQL server under a domain: Enter the name of the domain which the MS SQL server reside in. SQL server under a workgroup: Enter the computer name of the MS SQL server
User Name:	Enter the username of the SQL administrator Windows account.
Password:	Enter the username of the SQL administrator Windows account.





For OBM not installed on the MS SQL Server:



• Configure the temporary directory to a network path that is accessible by the SQL database server.





Important:
Please ensure that the MS SQL Server's SQL Windows service has read write permission to the network temporary directory.

Please update the service's [Log On] setting of the services if required.








For OBM installed on the MS SQL server:



• Configure the temporary directory to a local, USB or network path.





Important:
Please ensure that the MS SQL Server's SQL Windows service has read write permission to the network temporary directory.




• Scheduled backup will run automatically at the configured schedule time.
• Click [Backup] button on the left panel to perform a backup immediately.
• Select the backup type to be performed:






Menu Items	Description
Database - Complete	Perform a complete database backup.
Database - Differential	Perform a differential database backup.
Transaction Log	Perform a transaction log backup.




Back to top