Restoring backups to the new server

For each Tealeaf® database, follow these steps in SQL Server Management Studio, which must be connected to the new SQL Server instance.

1. Right-click the Databases folder in Object Explorer.
2. Select Restore Database....
3. Under Source for restore:
   • Select From device.
   • Select the ... button to the right of the From device box.
   • Select Add.
   • Select the backup file for the current database. In the above example, it is C:\tl_reports.bak. Click OK.
   • Click OK to return to the Restore Database window.
4. Under Select the backup sets to restore, select the Restore check box to the left of the newly added backup.
5. Under Destination for restore:
   • From the To database drop-down, select the name of the current database.
6. Under Select a page, select Options.
7. Select the check box next to Overwrite the existing database.
8. Under Restore the database files as, update the filegroups to reflect your filegroup paths.
9. Select Leave the database ready to use by rolling back uncommitted transactions.
10. Click OK.