Thursday, 15 June 2017

Backing up a database and storing it at a secure location is excellent practice for preventing data loss. This is implemented by data houses on a regular basis. DataSight databases can be backed up and restored on the SQL server. This document guides through the steps involved in restoring a DataSight database provided that it has been backed up correctly and is recoverable.

Prerequisites

Before proceeding to restore a backed up database, please ensure the following:

• DataSight Administrator is installed
• Microsoft SQL Management Studio is installed
• db_owner privilege is granted
• Backup file is available on the local disk for restore
• A backup can be restored on an existing DataSight database, or a new DataSight database.
  
  (i) If the backup is to be restored on an existing DataSight database, please proceed to restore.
  
  (ii) To restore backup file on a new database, use DataSight Administrator to create the new database first. Then proceed to restore.

Restore

Follow the steps below to successfully restore a DataSight database:

1. Connect to a DataSight server database engine and authenticate on the operating system or with a username and password.
2. Launch SQL Server Management Studio.
3. Select server type of Database Engine.
4. Enter server name.
5. Select Windows Authentication or SQL Server Authentication and authenticate credentials accordingly. SQL is connected to server database engine.
6. Drop down Databases to view available DataSight databases.
7. Select a destination database to restore backup on.
8. Right-click on the database.
9. Select Tasks > Restore > Database. A Restore Database window is launched. When a restore is initiated, the status of the Restore Database window should read “Ready”.
10. Select General page.
11. On the General page, set Source to Device.
12. Click … to browse and add location of backup file.
13. Select backup media type as File.
14. Click Add to supply location of the backup file on the local disk.
15. Locate the backup file on the device. Then click OK. The file location should display as backup media.
16. Click OK to prepare backup media. In a few moments, the backup file should be ready to be restored.
17. On the General page, set Destination to destination database. This is where the backup database will be restored.
18. Under Restore Plan, ensure that the checkbox in the Restore column is checked.
19. (Optional) If restoring on a new database, select Options page. Then under Restore Options, select Overwrite existing database (WITH REPLACE).
20. Click OK to run restore. Please wait while the database is being restored.
21. After a restore is successfully completed, a message will notify this. Click OK to accept.