SQL Restore

DESCRIPTION:

How to restore your MS SQL 2008 database from a previous backup. 

ARTICLE:

Restoring your MS SQL 2008 database from a previous backup will restore all of your Enterprise TV configuration settings, and recording jobs.

NOTE: If you are using Enterprise TV 5 in a clustering configuration, it is only necessary to restore the database that resides on the Master Node.

For instructions on backing up your database see this article: SQL Backup 


    1. You will want to temporarily stop our SnapStream Broker from running.
      Start > Administrative Tools > Services
      Right-click "SnapStream Broker", and select "Stop".

    2. Start > All Programs > Microsoft SQL Server 2008 > SQL Server Management Studio



      NOTE: You must be signed in to the server as a system administrator in order to connect here.

    3. Click the plus next to Databases, and right-click "SnapStreamTV". Go to Tasks > Restore > Database.





    4. When the Restore Database window comes up, select "Options" on the left hand side of the screen. Here you want to check off the option for "Overwrite the existing database (WITH REPLACE)".





    5. Now select "General" on the left hand side of the screen. This is where we need to specify the location of the backup that we are restoring.

      NOTE: If your backups have been saved to the default location, the path should already be selected for you. Skip to step 9 if this is the case.




    6. Select "From device", and click the button with three dots to specify the location of your backup up database.





    7. Backup Media should stay at "File". Now click the Add button to browse to your backup file.






      NOTE: You will not be able to browse to your backup here if this backup doesn't have the .bak extension. You can rename your backup file to include this extension if it doesn't have it already.




    8. You should now be back at the Restore Database window. Make sure that you have checked off the restore box for your backup and click OK.





    9. Click OK, and the backup will start. Once you see the message below, your backup is complete.




    10. Click OK and close the Restore dialog window.


    11. Click New Query.


    12. Download the following file: Fixdbuser.txt


    13. Copy the contents of the text file into the New Query box. Hit F5 to execute the query. You should see several lines of black text in the Messages box.


    14. You can now start the SnapStream Broker service back up.
      Start > Administrative Tools > Services
      Right-click "SnapStream Broker", and select "Start".
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk