1

Topic: Migrating database to new server

Is there a document on migrating a Recorder 6 database to a new server? I'm sure this exists but haven't been able to track it down!
Thanks
Andy

2

Re: Migrating database to new server

The procedure for migrating a Recorder 6 database (NBNData_Data.MDF, and the associated log file, nbndata_data_log.LDF) to a new server is very similar to swapping from MSDE to SQL Server 2000 – the instructions for which are in the Network Installation Guide (page 10) which is available from http://jncc.defra.gov.uk/page-4595 , except that you should use the SQL Server 2005/8 tools, called Management Studio Express, instead of Enterprise Manager, the SQL Server 2000 tools. Note that if you copy and paste the query in point 11, you often need to re-type the quotes before it will run.

Please note the points about SQL Server 2012 and Windows 8 in http://forums.nbn.org.uk/viewtopic.php?pid=18532#p18532 and that user added files like rucksacks and recording cards will also need to be transferred.

Sally Rankin, JNCC Recorder Approved Expert
E-mail: s.rankin@btinternet.com
Telephone: 01491 578633
Mobile: 07941 207687