Sophos Enterprise database migration issue

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: