May 31, 2011 at 9:47 am
I dettached a database so that i can move the files to a differnt drive which i have done many times but this time it is acting weird. I could not attach the database, it is taking for more than 45min now and still running, what might be the problem because i think attach would not take less than a minute.
May 31, 2011 at 9:53 am
NOt 100% sure about this but if the db wasn't cleanly shutdown or if there was a very long running transaction is has to be rolled forward / back before the db comes online.
Just PS, it's safer to backup / restore or COPY the files. That way if the move fails for any reason (most likely hardware) then the db is not lost in the process.
May 31, 2011 at 10:03 am
Anything in the SQL Server error log?
May 31, 2011 at 11:29 am
attaching the db is still runing from the past 3 hrs and is locking every one that server, i can t even open any database from the SSMS?
May 31, 2011 at 11:34 am
Can you get into the activity monitoring tools in Management Studio and see what SPIDs are doing what? Or open a connection and run sp_who2?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
May 31, 2011 at 11:54 am
yes, i can and i see activity "create database" for this attach database but it is not blocking anything
June 2, 2011 at 6:13 am
Pretty safe assumption you've already resolved this, but if not, what is blocking and what is eating up resources?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply