April 7, 2015 at 12:41 am
Hi All,
Why do I leave my DB in Restoring State after attaching to the instance? Could not this fire a redo activity on Transaction Log?
Or, How does sql server undo all uncommitted transactions on active vlf during recovery?
Regards,
April 7, 2015 at 2:30 am
??
A database doesn't go into restoring after an attach, It'll go online.
What are you doing, what behaviour are you seeing?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 7, 2015 at 7:28 am
Thinky Night (4/7/2015)
Hi All,Why do I leave my DB in Restoring State after attaching to the instance? Could not this fire a redo activity on Transaction Log?
Or, How does sql server undo all uncommitted transactions on active vlf during recovery?
Regards,
Does the database already exist, if so you're likely taking a tail log backup which is the default action. This will put the current database into restore mode
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply