Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Database went into Restoring State for unknown reason Expand / Collapse
Posted Wednesday, November 13, 2013 7:12 AM



Group: General Forum Members
Last Login: Friday, April 24, 2015 8:16 AM
Points: 7,163, Visits: 15,084
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"
Post #1513876
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse