Changing DB from MS SQL Server 2008 R2 to MS SQL Server 2014

Question

Hello, 
 I want to upgrade our Sophos DB from MS SQL Server 2008 R2 to MS SQL Server 2014. I found following documentation: 
 https://community.sophos.com/kb/en-us/110380 
 Backup the Databases with the script backupdb.bat was o.k., but restoring doesn&acute;t match, because the location of the mdf- and ldf-file are different at the new MS SQL Server 2014. How can I customize the restoredb.bat file with the "move to" option. Can anybody help me. 
 
 Klaussophos

QC · Accepted Answer

Hello Klaussophos , 
 per Microsoft's Restore a Database to a New Location and Sophos' Sql commands article use [WITH] MOVE 'logical_file_name_in_backup' TO 'operating_system_file_name' . Haven't done this so the following modification is untested: 
 ... WITH FILE = @backupsetnumber, MOVE '%databaseName%' TO ' X:
ew\path \%databaseName%.mdf', MOVE '%databaseName%_log' TO ' X:
ew\path \%databaseName%_log.ldf', REPLACE, ... 
 Christian

Klaussophos · Answer

Hello Christian, 
 thanks a lot. My problem is solved with your code. 
 
 Klaussophos