Hi,
I have an sql error when we restore the backup sophos database47 in a new windows server 2008 r2.
I backup Sql server 2008 express.
Restore to Sql server 2012 espress.
Running both Windows server 2008 r2.
C:\Program Files\Sophos\Enterprise Console\DB>restoredb.bat c:\backup47\sec
47.bak
Disabling access to the database ...
C:\Program Files\Sophos\Enterprise Console\DB>sqlcmd -E -S "SQLSERVER2012\SOPHOS
" -d "master" -b -Q "RESTORE DATABASE SOPHOS47 FROM DISK = 'c:\backup47\sec47.ba
k' WITH REPLACE, RECOVERY"
Msg 5133, Level 16, State 1, Server SQLSERVER2012\SOPHOS, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SOP
HOS\MSSQL\DATA\SOPHOS47.mdf" failed with the operating system error 3(The system
cannot find the path specified.).
Msg 3156, Level 16, State 3, Server SQLSERVER2012\SOPHOS, Line 1
File 'SOPHOS47' cannot be restored to 'C:\Program Files\Microsoft SQL Server\MSS
QL10.SOPHOS\MSSQL\DATA\SOPHOS47.mdf'. Use WITH MOVE to identify a valid location
for the file.
Msg 5133, Level 16, State 1, Server SQLSERVER2012\SOPHOS, Line 1
Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL10.SOP
HOS\MSSQL\DATA\SOPHOS47_log.LDF" failed with the operating system error 3(The sy
stem cannot find the path specified.).
Msg 3156, Level 16, State 3, Server SQLSERVER2012\SOPHOS, Line 1
File 'SOPHOS47_log' cannot be restored to 'C:\Program Files\Microsoft SQL Server
\MSSQL10.SOPHOS\MSSQL\DATA\SOPHOS47_log.LDF'. Use WITH MOVE to identify a valid
location for the file.
Msg 3119, Level 16, State 1, Server SQLSERVER2012\SOPHOS, Line 1
Problems were identified while planning for the RESTORE statement. Previous mess
ages provide details.
Msg 3013, Level 16, State 1, Server SQLSERVER2012\SOPHOS, Line 1
RESTORE DATABASE is terminating abnormally.
Failed to restore
Enabling access to the database ...
C:\Program Files\Sophos\Enterprise Console\DB>sqlcmd -E -S "SQLSERVER2012\SOPHOS
" -d "master" -b -Q "ALTER DATABASE SOPHOS47 SET ONLINE"
Can anyone help me?
Best regards,
tedz
This thread was automatically locked due to age.
