Grant Fritchey (11/7/2013)
GilaMonster (11/6/2013)
Restoring or recovering?A DB will go restoring if someone runs BACKUP LOG ... WITH NORECOVERY ....
In what might be an epic role reversal, don't you mean RESTORE LOG etc.?
Gail is correct here, BACKUP LOG WITH NORECOVERY is used to take a tail log backup and is also used for role switching in a log shipping configuration.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉