Restore Log Fails Msg:3433 -
04-07-2005
, 09:28 AM
Server: Msg 3443, Level 20, State 1, Line 1
Database 'GAII_Build' (database ID 8) was marked for standby or
read-only use, but has been modified. The RESTORE LOG statement cannot
be performed.
Scenario: win2003, sql2k sp3a.
Manual log shipping - ftp logs to server, restore in situ.
Looks like the log ftp across ran out of disk space - down to
0bytes...
Never the less it seems to have tried to restore it.
Database in Load.
execed
restore log <>
from disk = <>
with restart,
stats = 5,
standby = <>
Now just get the error message above...
Any ideas? Recover from start... is not the preferred alternative! |