Problems with Enterprise Console Migration Step 8.4

I am in the process of migrating Enterprise Console 5.2.1 from a 32-bit Windows 2003 to Server 2012 Standard.

Have follwowed the migration guide sucessfully until step 8.4 which is restoring the database.

The guide does state that i need to create a ManamentServer folder in %alluserprofile%\application data\Sophos.  Which as far as i can tell for Windows Server 2012 is C:\ProgramData\Sophos\  (please advise if this is incorrect).

I receive the following errors when running the DataBackupRestore -Action=Restore -DataSourceType=Database;

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>DataBackupRestor e -action=restore -datasourcetype=database Are you sure you want to restore database in all? (Y/N) y Microsoft (R) Build Engine version 4.0.30319.17929 [Microsoft .NET Framework, version 4.0.30319.18051] Copyright (C) Microsoft Corporation. All rights reserved.

Build started 13/09/2013 04:16:13. Copy file C:\ProgramData\Sophos\ManagementServer\Backup\Databases\SOPHOSENC52.ba k successful.

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>sqlcmd -E -S "(l ocal)\SOPHOS" -d "master" -b -Q "IF EXISTS (SELECT name FROM master.dbo.sysdatab ases WHERE name = N'SOPHOSENC52') BEGIN ALTER DATABASE SOPHOSENC52 SET OFFLINE W ITH ROLLBACK AFTER 5 END" Attempting restore with SQL2012 backup schema.

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>sqlcmd -E -S "(l ocal)\SOPHOS" -d "master" -b -Q "CREATE TABLE #backupSetInfo (BackupName NVARCHA R(128),BackupDescription NVARCHAR(255),BackupType smallint,ExpirationDate dateti me,Compressed tinyint,Position smallint,DeviceType tinyint,UserName NVARCHAR(128 ),ServerName NVARCHAR(128),DatabaseName NVARCHAR(128),DatabaseVersion INT,Databa seCreationDate datetime,BackupSize numeric(20,0),FirstLSN numeric(25,0),LastLSN numeric(25,0),CheckpointLSN numeric(25,0),DatabaseBackupLSN numeric(25,0),Backup StartDate datetime,BackupFinishDate datetime,SortOrder smallint,CodePage smallin t,UnicodeLocaleId INT,UnicodeComparisonStyle INT,CompatibilityLevel tinyint,Soft wareVendorId INT,SoftwareVersionMajor INT,SoftwareVersionMinor INT,SoftwareVersi onBuild INT,MachineName NVARCHAR(128),Flags INT,BindingID uniqueidentifier,Recov eryForkID uniqueidentifier,Collation NVARCHAR(128),FamilyGUID uniqueidentifier,H asBulkLoggedData INT,IsSnapshot INT,IsReadOnly INT,IsSingleUser INT,HasBackupChe cksums INT,IsDamaged INT,BeginsLogChain INT,HasIncompleteMetaData INT,IsForceOff line INT,IsCopyOnly INT,FirstRecoveryForkID uniqueidentifier,ForkPointLSN numeri c(25,0),RecoveryModel NVARCHAR(128),DifferentialBaseLSN numeric(25,0),Differenti alBaseGUID uniqueidentifier,BackupTypeDescription NVARCHAR(128),BackupSetGUID un iqueidentifier,CompressedBackupSize INT,containment tinyint); INSERT #backupSetI nfo EXEC('RESTORE HEADERONLY FROM DISK=N' + '''C:\ProgramData\Sophos\TempData\SO PHOSENC52.bak'''); DECLARE @backupsetnumber smallint; SET @backupsetnumber = (SE LECT TOP(1) Position FROM #backupSetInfo ORDER BY BackupFinishDate DESC); RESTOR E DATABASE SOPHOSENC52 FROM DISK = 'C:\ProgramData\Sophos\TempData\SOPHOSENC52.b ak' WITH FILE = @backupsetnumber, REPLACE, RECOVERY; DROP TABLE #backupSetInfo;"

Msg 213, Level 16, State 7, Server SERVER\SOPHOS, Line 1 Column name or number of supplied values does not match table definition. Msg 3013, Level 16, State 1, Server SERVER\SOPHOS, Line 1 RESTORE HEADERONLY is terminating abnormally. Msg 3250, Level 16, State 1, Server SERVER\SOPHOS, Line 1 The value '0' is not within range for the FILE parameter. Msg 3013, Level 16, State 1, Server SERVER\SOPHOS, Line 1 RESTORE DATABASE is terminating abnormally. Attempting restore with SQL2008/SQL2008R2 backup schema.

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>sqlcmd -E -S "(l ocal)\SOPHOS" -d "master" -b -Q "CREATE TABLE #backupSetInfo (BackupName NVARCHA R(128),BackupDescription NVARCHAR(255),BackupType smallint,ExpirationDate dateti me,Compressed tinyint,Position smallint,DeviceType tinyint,UserName NVARCHAR(128 ),ServerName NVARCHAR(128),DatabaseName NVARCHAR(128),DatabaseVersion INT,Databa seCreationDate datetime,BackupSize numeric(20,0),FirstLSN numeric(25,0),LastLSN numeric(25,0),CheckpointLSN numeric(25,0),DatabaseBackupLSN numeric(25,0),Backup StartDate datetime,BackupFinishDate datetime,SortOrder smallint,CodePage smallin t,UnicodeLocaleId INT,UnicodeComparisonStyle INT,CompatibilityLevel tinyint,Soft wareVendorId INT,SoftwareVersionMajor INT,SoftwareVersionMinor INT,SoftwareVersi onBuild INT,MachineName NVARCHAR(128),Flags INT,BindingID uniqueidentifier,Recov eryForkID uniqueidentifier,Collation NVARCHAR(128),FamilyGUID uniqueidentifier,H asBulkLoggedData INT,IsSnapshot INT,IsReadOnly INT,IsSingleUser INT,HasBackupChe cksums INT,IsDamaged INT,BeginsLogChain INT,HasIncompleteMetaData INT,IsForceOff line INT,IsCopyOnly INT,FirstRecoveryForkID uniqueidentifier,ForkPointLSN numeri c(25,0),RecoveryModel NVARCHAR(128),DifferentialBaseLSN numeric(25,0),Differenti alBaseGUID uniqueidentifier,BackupTypeDescription NVARCHAR(128),BackupSetGUID un iqueidentifier,CompressedBackupSize INT); INSERT #backupSetInfo EXEC('RESTORE HE ADERONLY FROM DISK=N' + '''C:\ProgramData\Sophos\TempData\SOPHOSENC52.bak'''); D ECLARE @backupsetnumber smallint; SET @backupsetnumber = (SELECT TOP(1) Position  FROM #backupSetInfo ORDER BY BackupFinishDate DESC); RESTORE DATABASE SOPHOSENC 52 FROM DISK = 'C:\ProgramData\Sophos\TempData\SOPHOSENC52.bak' WITH FILE = @bac kupsetnumber, REPLACE, RECOVERY; DROP TABLE #backupSetInfo;"

(1 rows affected) Msg 5133, Level 16, State 1, Server SERVER\SOPHOS, Line 1 Directory lookup for the file "c:\Program Files\Microsoft SQL Server\MSSQL10.SOP HOS\MSSQL\DATA\SOPHOSENC52.mdf" failed with the operating system error 3(failed to retrieve text for this error. Reason: 15105). Msg 3156, Level 16, State 3, Server SERVER\SOPHOS, Line 1 File 'SOPHOSENC51' cannot be restored to 'c:\Program Files\Microsoft SQL Server\ MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSENC52.mdf'. Use WITH MOVE to identify a valid lo cation for the file. Msg 5133, Level 16, State 1, Server SERVER\SOPHOS, Line 1 Directory lookup for the file "c:\Program Files\Microsoft SQL Server\MSSQL10.SOP HOS\MSSQL\DATA\SOPHOSENC52.ldf" failed with the operating system error 3(failed to retrieve text for this error. Reason: 15105). Msg 3156, Level 16, State 3, Server SERVER\SOPHOS, Line 1 File 'SOPHOSENC51_log' cannot be restored to 'c:\Program Files\Microsoft SQL Ser ver\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOSENC52.ldf'. Use WITH MOVE to identify a vali d location for the file. Msg 3119, Level 16, State 1, Server SERVER\SOPHOS, Line 1 Problems were identified while planning for the RESTORE statement. Previous mess ages provide details. Msg 3013, Level 16, State 1, Server SERVER\SOPHOS, Line 1 RESTORE DATABASE is terminating abnormally. Attempting restore with SQL2005 backup schema.

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>sqlcmd -E -S "(l ocal)\SOPHOS" -d "master" -b -Q "CREATE TABLE #backupSetInfo (BackupName NVARCHA R(128),BackupDescription NVARCHAR(255),BackupType smallint,ExpirationDate dateti me,Compressed tinyint,Position smallint,DeviceType tinyint,UserName NVARCHAR(128 ),ServerName NVARCHAR(128),DatabaseName NVARCHAR(128),DatabaseVersion INT,Databa seCreationDate datetime,BackupSize numeric(20,0),FirstLSN numeric(25,0),LastLSN numeric(25,0),CheckpointLSN numeric(25,0),DatabaseBackupLSN numeric(25,0),Backup StartDate datetime,BackupFinishDate datetime,SortOrder smallint,CodePage smallin t,UnicodeLocaleId INT,UnicodeComparisonStyle INT,CompatibilityLevel tinyint,Soft wareVendorId INT,SoftwareVersionMajor INT,SoftwareVersionMinor INT,SoftwareVersi onBuild INT,MachineName NVARCHAR(128),Flags INT,BindingID uniqueidentifier,Recov eryForkID uniqueidentifier,Collation NVARCHAR(128),FamilyGUID uniqueidentifier,H asBulkLoggedData INT,IsSnapshot INT,IsReadOnly INT,IsSingleUser INT,HasBackupChe cksums INT,IsDamaged INT,BeginsLogChain INT,HasIncompleteMetaData INT,IsForceOff line INT,IsCopyOnly INT,FirstRecoveryForkID uniqueidentifier,ForkPointLSN numeri c(25,0),RecoveryModel NVARCHAR(128),DifferentialBaseLSN numeric(25,0),Differenti alBaseGUID uniqueidentifier,BackupTypeDescription NVARCHAR(128),BackupSetGUID un iqueidentifier); INSERT #backupSetInfo EXEC('RESTORE HEADERONLY FROM DISK=N' + ' ''C:\ProgramData\Sophos\TempData\SOPHOSENC52.bak'''); DECLARE @backupsetnumber s mallint; SET @backupsetnumber = (SELECT TOP(1) Position FROM #backupSetInfo ORDE R BY BackupFinishDate DESC); RESTORE DATABASE SOPHOSENC52 FROM DISK = 'C:\Progra mData\Sophos\TempData\SOPHOSENC52.bak' WITH FILE = @backupsetnumber, REPLACE, RE COVERY; DROP TABLE #backupSetInfo;" Msg 213, Level 16, State 7, Server SERVER\SOPHOS, Line 1 Column name or number of supplied values does not match table definition. Msg 3013, Level 16, State 1, Server SERVER\SOPHOS, Line 1 RESTORE HEADERONLY is terminating abnormally. Msg 3250, Level 16, State 1, Server SERVER\SOPHOS, Line 1 The value '0' is not within range for the FILE parameter. Msg 3013, Level 16, State 1, Server SERVER\SOPHOS, Line 1 RESTORE DATABASE is terminating abnormally. Failed to restore

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>sqlcmd -E -S "(l ocal)\SOPHOS" -d "master" -b -Q "ALTER DATABASE SOPHOSENC52 SET ONLINE"

C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore>sqlcmd -E -S "(l ocal)\SOPHOS" -d "SOPHOSENC52" -b -i ResetUserMappings.sql Process 'C:\ProgramData\Sophos\ManagementServer\Backup\DataBackupRestore\TRS.bat  (local)\SOPHOS SOPHOSENC52 "C:\ProgramData\Sophos\TempData\SOPHOSENC52.bak"' re turned Error 1

Build FAILED.

Time Elapsed 00:00:01.31 Process 'C:\Windows\Microsoft.NET\Framework64\v4.0.30319\msbuild.exe "C:\Program Data\Sophos\ManagementServer\Backup\DataBackupRestore"\BackupRestore.proj /t:res tore /clp:NoSummary /p:SubSystem=all;DataSourceType=database;ExcludeDB=False;Loc ationSpecific=False;SlientMode=False;DBServerInstance=' returned Error 1

----

As fas as i can tell the table definitions are not matching thus has a knock on effect for the rest of the restore.

I would be grateful if anyone has any ideas as to what could be causing this. 

The backup of the old server was completed sucessfully.