BIG PROBLEM! Production db marked (loading)

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Andy Warren SSC Guru Points: 119902 More actions · Answer 1

Try this:

RESTORE DATABASE MyNwind

WITH RECOVERY

Andy

mhenriks SSC Eights! Points: 969 More actions · Answer 2

Thanks a bunch Andy! that worked.

Should I change the recovery mode of the backup db now so the log shipping restores will work again?

Andy Warren SSC Guru Points: 119902 More actions · Answer 3

Think you have to put it back in standby.

Andy

Cookies on SQLServerCentral