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
  • Hi, We are getting the same database retore error message as the above. Was there a solution for this?

    We are migrating from SEC 5.1 on SBS2008 to SEC 5.2 on Server 2012 R2 (SQL 2012)

    Any help would be much appreciated.

    :51038
Reply
  • Hi, We are getting the same database retore error message as the above. Was there a solution for this?

    We are migrating from SEC 5.1 on SBS2008 to SEC 5.2 on Server 2012 R2 (SQL 2012)

    Any help would be much appreciated.

    :51038
Children
No Data