Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smorty44
Yak Posting Veteran
93 Posts |
 Posted - 2007-09-28 : 09:28:00
|
| I need to detach a db. When I right click and choose detach the popup box shows 0 connections however, I'm getting the error 3701 cannot detach because it's currently in use. How can I tell what is causing this or what is using the db? |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-09-28 : 09:35:26
|
| You have to bring the database to SINGLE_USER mode using ALTER DATABASE.Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-28 : 21:52:22
|
| Why can't you backup the db? |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2007-09-29 : 05:14:06
|
| Why are you detaching? is it so you can create a new log file?Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com/SQL |
|
|
|
|
|
|
Detaching Database