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

    RestoreDB takes the database name as optional third argument. After you have restored the SOPHOS4 database you must run UpgradeDB.exe. 

    Have you already planned how to "move" the clients to the new server?

    Christian

    :7605
Reply
  • 0

    RestoreDB takes the database name as optional third argument. After you have restored the SOPHOS4 database you must run UpgradeDB.exe. 

    Have you already planned how to "move" the clients to the new server?

    Christian

    :7605
Children
No Data