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

migrating Enterprise console 5.0 error

I am trying to migrate enterprise console to a new server using Sophos Enterprise Console server to server migration guide, and when importing database to a new server i get build sucesfully, but i get errors

C:\Program Files\Sophos\Enterprise Console>sqlcmd -E -S "(local)\SOPHOS" -d "mas
ter" -b -Q "CREATE TABLE #backupSetInfo (BackupName NVARCHAR(128),BackupDescript
ion NVARCHAR(255),BackupType smallint,ExpirationDate datetime,Compressed tinyint
,Position smallint,DeviceType tinyint,UserName NVARCHAR(128),ServerName NVARCHAR
(128),DatabaseName NVARCHAR(128),DatabaseVersion INT,DatabaseCreationDate dateti
me,BackupSize numeric(20,0),FirstLSN numeric(25,0),LastLSN numeric(25,0),Checkpo
intLSN numeric(25,0),DatabaseBackupLSN numeric(25,0),BackupStartDate datetime,Ba
ckupFinishDate datetime,SortOrder smallint,CodePage smallint,UnicodeLocaleId INT
,UnicodeComparisonStyle INT,CompatibilityLevel tinyint,SoftwareVendorId INT,Soft
wareVersionMajor INT,SoftwareVersionMinor INT,SoftwareVersionBuild INT,MachineNa
me NVARCHAR(128),Flags INT,BindingID uniqueidentifier,RecoveryForkID uniqueident
ifier,Collation NVARCHAR(128),FamilyGUID uniqueidentifier,HasBulkLoggedData INT,
IsSnapshot INT,IsReadOnly INT,IsSingleUser INT,HasBackupChecksums INT,IsDamaged
INT,BeginsLogChain INT,HasIncompleteMetaData INT,IsForceOffline INT,IsCopyOnly I
NT,FirstRecoveryForkID uniqueidentifier,ForkPointLSN numeric(25,0),RecoveryModel
 NVARCHAR(128),DifferentialBaseLSN numeric(25,0),DifferentialBaseGUID uniqueiden
tifier,BackupTypeDescription NVARCHAR(128),BackupSetGUID uniqueidentifier); INSE
RT #backupSetInfo EXEC('RESTORE HEADERONLY FROM DISK=N' + '''SOPHOS50.bak'''); D
ECLARE @backupsetnumber smallint; SET @backupsetnumber = (SELECT TOP(1) Position
 FROM #backupSetInfo ORDER BY BackupFinishDate DESC); RESTORE DATABASE SOPHOS50
FROM DISK = 'SOPHOS50.bak' WITH FILE = @backupsetnumber, REPLACE, RECOVERY; DROP
 TABLE #backupSetInfo;"
Msg 213, Level 16, State 7, Server SAV\SOPHOS, Line 1
Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Server SAV\SOPHOS, Line 1
RESTORE HEADERONLY is terminating abnormally.
Msg 3250, Level 16, State 1, Server SAV\SOPHOS, Line 1
The value '0' is not within range for the FILE parameter.
Msg 3013, Level 16, State 1, Server SAV\SOPHOS, Line 1
RESTORE DATABASE is terminating abnormally.
Failed to restore

both servers have same users, are on same domain, same version of OS (windows 2003 standard 32bit) and SEC

old server was upgraded from version 4.5

after restoring in new console I get whole settings from old server and connection to old console (should be connected to console on new server) and I don't have new SUM

can anyone help

thanks in advance

:36281


This thread was automatically locked due to age.
Parents
  • the registry says local\sophos

    This - assuming it is (local) - shouldn't cause the "new" management server to connect to the "old" database. When you had to change it - can you remember what was there instead on the new server?

    Dunno where the likely error disappeared to - as said before, it's apparently trying SQL2005 (in TRS.bat or RestoreDB.bat) and that this fails at RESTORE HEADERONLY) is expected given you run 2008. It should only try 2005 though if there was a failure when trying 2008 (in which case it should at least echo SQL2008 Statement failed, try SQL2005 statement).

    Christian

    :36331
Reply
  • the registry says local\sophos

    This - assuming it is (local) - shouldn't cause the "new" management server to connect to the "old" database. When you had to change it - can you remember what was there instead on the new server?

    Dunno where the likely error disappeared to - as said before, it's apparently trying SQL2005 (in TRS.bat or RestoreDB.bat) and that this fails at RESTORE HEADERONLY) is expected given you run 2008. It should only try 2005 though if there was a failure when trying 2008 (in which case it should at least echo SQL2008 Statement failed, try SQL2005 statement).

    Christian

    :36331
Children
No Data