(powered by Google Mini, searches all knowledgebase articles, forums and help files)
Knowledgebase: Enterprise TV
SQL Backup
Posted by Adrienne Gonzalez on 15 March 2011 03:05 PM

DESCRIPTION:

How to backup your MS SQL 2008 database.

ARTICLE:

It is highly recommended that Enterprise TV 5 users periodically backup the MS SQL 2008 database. This database holds 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 backup the database that resides on the Master Node.


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


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

  2. Click the plus next to Databases, and right-click "SnapStreamTV". Go to Tasks > Backup.



  3. When the Backup Database Windows comes up, specify the destination of where you want your backup to go.

    NOTE: You can remove the default path and add a different one by using the add and remove buttons at the bottom of the screen. When adding a new path, make sure to add the .bak extension to the filename.



  4. Click OK, and the backup will start. Once you see the message below, your backup is complete.
SnapStream Media, Inc.