469,898 Members | 1,797 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,898 developers. It's quick & easy.

Restore Log Fails Msg:3433

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!
Jul 23 '05 #1
0 957

This discussion thread is closed

Replies have been disabled for this discussion.

By using this site, you agree to our Privacy Policy and Terms of Use.