Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 1 reply
  • Subscribers 1 subscriber
  • Views 1892 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

how do I migrate the DB from previous SQL (2005, 2008, 2008 R2) to SQL 2012?

divadiow

I have a few of these to do, but in this instance 5.2.1 EC is installed on a single server, running fine, SOPHOS instance is on SQL 2005.

Would like to move it on to SQL 2012 instance WITH THE SAME NAME. so I'd need to ditch the 2005 instance first before restoring to the DB to a new 2012 instance.

any pointers on the steps needed?

:42416


This thread was automatically locked due to age.
  • 0

    Hello divadiow,

    I'm not a SQL expert, but there should be no need to get rid of the 2005 instance. Please see the Upgrade to SQL Server 2012 article by Microsoft. So basically you stop the Sophos services, backup your databases just in case and upgrade SQL server.

    Otherwise you'd stop the services, back up the databases, remove SQL 2005, install the 2012 instance and restore the databases (Note: as the path for the database files is different in 2005 and 2012 and for 32bit and 64bit versions you have to manually restore as outlined here).

    HTH

    Christian

    :42444