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
  • when I use DataBackupRestore-Action=Restore to restore data on new server database connection in registry points to old server (console is working only if old server is on, and i don't have new SUM), so I changed database connection in registry to point to the new server (is that wrong step)

    as for SQL, yes, it was 2005 and when I upgraded to 5.0 it changed to 2008 wihtout a problem

    as for backing up the data, I tried to use both procedures backupdb.bat and databackuprestore and didn't get any errors with either of them (had error with cac.pem and solved it with procedure that I found in databaserestore maunal)

    :36315
Reply
  • when I use DataBackupRestore-Action=Restore to restore data on new server database connection in registry points to old server (console is working only if old server is on, and i don't have new SUM), so I changed database connection in registry to point to the new server (is that wrong step)

    as for SQL, yes, it was 2005 and when I upgraded to 5.0 it changed to 2008 wihtout a problem

    as for backing up the data, I tried to use both procedures backupdb.bat and databackuprestore and didn't get any errors with either of them (had error with cac.pem and solved it with procedure that I found in databaserestore maunal)

    :36315
Children
No Data