I’’’’m trying to migrate our 5.2.1R2 DB’’’’s from an old SQL2005 box to a new SQL2012 box by following article 22468. I’’’’ve run backupdb.bat and backed up all of the DB’’’’s. The trouble I’’’’m having is restoring them to the new server as the locations of the DB files is different on the new server compared to the old, and as restored.bat use the file location info found in the backup file I can’’’’t restore the files to the new location.
I currently have a support call open for this issue but its been dragging on (2 weeks now!). I've been told all I need to do is run the EM insatller on the new SQL2012 box to create the blank DB's, and then rerun the EM installer on the current EM server and change the DB details (servername\instance) to point to the new SQL server. Anyway when I startup the EM console it connects to the new DB server but I don't have any of our settings so its obviously just connecting to the newly created blank DB's on the new SQL server, the DB migration from the old SQL server has failed.
So can I not just do as above but manually restore the backed up DB's on the new SQL box by using the following SQL command
sqlcmd -E -S .\sophos -Q "restore database sophos52 from disk='C:\sophos52db.bak' WITH REPLACE, MOVE 'sophos52' to 'E:\Program Files\Microsoft SQL Server\MSSQL\data\SOPHOS52.MDF', Move 'SOPHOS52_Log' to 'E:\Program Files\Microsoft SQL Server\MSSQL\data\SOPHOS52_Log.LDF'"
or by using SQL management studio?
This thread was automatically locked due to age.
