(powered by Google Mini, searches all knowledgebase articles, forums and help files)
Knowledgebase: Enterprise TV
SQL Restore
Posted by Adrienne Gonzalez on 16 March 2011 08:32 AM

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


    3. 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. Now download the following file: fixDbUser


  11. Extract the folder in the zip to your desktop, and run fixDbUser.bat.


  12. You can now start the SnapStream Broker service back up.
    Start > Administrative Tools > Services
    Right-click "SnapStream Broker", and select "Start".
SnapStream Media, Inc.