Okay, you've had a couple of days to work on this, what's happening?

mark.veitch (2/1/2010)

---

Thank you very much Lowell. Just had a quick scan and although this is new to me I'm thinking it might be a possibility. About to sign...

DHeath (2/3/2010)

---

So any thoughts on this solution..its a bad one i know already but it may be all i have...

1. Shut down mssql server

2. Delete all corresponding mdf /ldf files

3....

If you don't hear from me right away, it's because I have to leave now and get my kid from church. I'll check back when I get home.

Can you provide the full T-SQL command you used when restoring the databse that is now stuck?

Have to ask. Which database is stuck, the old one or the new one? How were you moving the database from the old server to the new server?

Have you shutdown the sharepoint services? If they are still running, that may be why you still get the error that the database is still in use.

Also, do you have any snaphot databases on this database?

DHeath (2/3/2010)

---

Thanks for the suggestion but when i try that this is the error..

restore database WSS_1 with recovery;

Msg 3101, Level 16, State 1, Line 1

Exclusive access could not be obtained...

How about:

restore database < your dbname here > with recovery;

Edit: No angle brackets, either.

CirquedeSQLeil (2/3/2010)

---

Lynn Pettis (2/3/2010)

---

CirquedeSQLeil (2/3/2010)

---

Just an FYI Lynn, I am looking into this but it is taking me longer than expected. I am thinking you could get away with...

Jack Corbett (2/3/2010)

---

And it probably wasn't me. Now I feel bad. :crying:

I haven't...

Congrats Jack!! :w00t:

I feel slighted, only 1 person even acknowledge when I hit 10,000. 🙁

CirquedeSQLeil (2/3/2010)

---

Just an FYI Lynn, I am looking into this but it is taking me longer than expected. I am thinking you could get away with ddladmin but that...

I was literally living on 4 hours of sleep a day for 5 days a week while commuting to/from Denver. I'd get to bed arounf 11 PM and get...