Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 8 replies
  • Subscribers 1 subscriber
  • Views 16804 views
  • Users 0 members are here
Options
Suggested
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

Sophos Enterprise database migration issue

thomas130

Hi guys

I'm trying to migrate our company sophos onto another server

Currently server ( windows server 2003, Running Sophos Enterprise 4.0.0.2362, using sql 2005)

Server I'm planning to upgrade to ( windows server 2008 service pack 2, Running Sophos Enterprise 4.5, using sql 2008)

The issue I get is when I try to import the database I get the following error message

Disabling access to the database ...

c:\Program Files\Sophos\Enterprise Console\DB>osql -E -S "SOPHOS\SOPHOS" -d "mas
ter" -n -b -Q "IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name =
N'SOPHOS45') BEGIN ALTER DATABASE SOPHOS45 SET OFFLINE WITH ROLLBACK AFTER 5 END
"

Restoring the database ...

c:\Program Files\Sophos\Enterprise Console\DB>osql -E -S "SOPHOS\SOPHOS" -d "mas
ter" -n -b -Q "RESTORE DATABASE SOPHOS45 FROM DISK = 'c:\SECBackup\SOPHOS.bak' W
ITH REPLACE, RECOVERY"
Msg 5133, Level 16, State 1, Server SOPHOS\SOPHOS, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\SOPHOS4.mdf" failed with the operating system error
3(failed to retrieve text for this error. Reason: 15100).
Msg 3156, Level 16, State 3, Server SOPHOS\SOPHOS, Line 1
File 'SOPHOS4' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\SOPHOS4.mdf'. Use WITH MOVE to identify a valid
location for the file.
Msg 5133, Level 16, State 1, Server SOPHOS\SOPHOS, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\SOPHOS4_log.LDF" failed with the operating system
error 3(failed to retrieve text for this error. Reason: 15105).
Msg 3156, Level 16, State 3, Server SOPHOS\SOPHOS, Line 1
File 'SOPHOS4_log' cannot be restored to 'C:\Program Files\Microsoft SQL
Server\MSSQL.1\MSSQL\DATA\SOPHOS4_log.LDF'. Use WITH MOVE to identify a valid
location for the file.
Msg 3119, Level 16, State 1, Server SOPHOS\SOPHOS, Line 1
Problems were identified while planning for the RESTORE statement. Previous
messages provide details.
Msg 3013, Level 16, State 1, Server SOPHOS\SOPHOS, Line 1
RESTORE DATABASE is terminating abnormally.
Failed to restore

I'm not sure If I'm right but I would assume it would have something to do with going from sql 2005 to 2008. Could some please advice whether this is the case or not how to resolve this issue

Thanks

Tom

:smileyhappy:

:7599


This thread was automatically locked due to age.
Parents
  • 0

    Hi Christian, thanks for the reply.

    Yes, I used backupdb on the 2k3 server (SQL 9.00.3042.00 - 2005 sp2 - build 3790), but the SEC version is 4.0. Have just had a very useful phone conversation, the conclusion being that I should upgrade to SQL 2005 SP3 first, and then SEC 4.5 before attempting another export. Another option would be to manually recreate our AD syncs etc., but I've been asked by my colleague to pursue the upgrade option first. Using VMWare, so potentially rolling back snapshots is a nice safety net!

    First class phone support btw :)

    Many thanks,

    James

    :10501
Reply
  • 0

    Hi Christian, thanks for the reply.

    Yes, I used backupdb on the 2k3 server (SQL 9.00.3042.00 - 2005 sp2 - build 3790), but the SEC version is 4.0. Have just had a very useful phone conversation, the conclusion being that I should upgrade to SQL 2005 SP3 first, and then SEC 4.5 before attempting another export. Another option would be to manually recreate our AD syncs etc., but I've been asked by my colleague to pursue the upgrade option first. Using VMWare, so potentially rolling back snapshots is a nice safety net!

    First class phone support btw :)

    Many thanks,

    James

    :10501
Children
No Data