Grass Valley NewsShare v.5.5 - Manual (Page 111)

Digital News Production 109
Creating a Backup from the Working FSM
1. Proceeding requires that the FSMs be taken out of service. Close all DNP
applications on all NewsShare clients. Follow the Open SAN procedures to
cleanly stop the Failover Monitor service on first the backup FSM, then the
primary FSM.
2. Using SQL Server Enterprise Manager, verify that replication has been
stopped on the primary FSM. This is extremely important.
3. Verify that there are no open transactions by running the command dbcc
opentran against the News database in SQL Server Query Analyzer or by
using the replCheck.bat utility in the attached replUtilities.zip file.
4. Follow the procedure “Backing Up the Database” on page 98. This
information is also available in the News Database Utilities.htm document
that can be found on an FSM or DSM in directory C:\Program Files\Vibrint
3.0\DB Maintenance. You’ll need to back up to a local file, then use
networking, memory sticks or other removable media to make the file
available to the DSM for restoration.
Installing the Backup onto the DSM
1. Using the backup file you created, restore the News database on the DSM by
following the procedure “Restoring the Database from a Backup” on page
99.
2. Verify that there are no open transactions by running the command dbcc
opentran against the News database in SQL Server Query Analyzer.