Grass Valley Aurora Ingest v.7.0.0 - Manual (Page 52)

NOTE: DO NOT delete Aurora Ingest folder in the registry key and 2 files (IS_Data.mdf
and IS_Log.ldf) in C:\Program Files\Microsoft SQL Server\90\Tools\Binn if you don’t have
a backup on another machine or an external drive. All data in the current database could
not be retrieved if those files were to be deleted and the system crashed.
Migrating Aurora Ingest - Server
Database migration should be done if you need to move Aurora Ingest database from
the current machine to a brand new machine, or to move your Aurora Ingest database
to the machine that runs your NewsShare DSM.
This means that both news database and ingest database will share the same SQL
processes. If you want to move your current Aurora Ingest database that runs on SQL
Express 2005 to your NewsShare DSM machine that runs the full version of SQL
Server 2005, you can do so by migrating your database.
1. Run the latest Aurora Ingest installer on the existing machine to update the Aurora
Ingest database.
2. Export the Aurora Ingest Server registry key under “My
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Grass Valley\Aurora
Ingest\Server” from existing machine.
DO NOT launch the Microsoft SQL Server Management Studio Express CTP
on both existing machine and new machine. If you do this, you cannot back up
the database.
3. Shut down the Aurora Ingest - Server application on the existing machine and copy
two files (IS_Data.MDF and IS_Log.LDF) from C:\Program Files\Microsoft SQL
Server\90\Tools\Binn from existing machine to same directory path in new machine.
Make sure these two files are NON-READ ONLY.
4. Make sure the “SQLServer (or SQLEXPRESS)” service is running on new machine.
You can check the state of the service in the “Services” application.
5. Launch the Microsoft SQL Server Management Studio Express CTP on new
machine.
6. Log on, using Window Authentication Mode, to attach the Aurora Ingest database.
7. Attach the Aurora Ingest database as shown in the following screenshot.
52 Aurora Ingest System Guide 14 April 2010
Managing Software