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 |
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
 Posted - 2007-03-30 : 16:40:36
|
| What is the difference between Detach and TakeofLine (EM->db->right click)------------------------I think, therefore I am - Rene Descartes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-03-30 : 16:51:30
|
| Taking offline a database makes the database inaccessible to anyone, but it doesn't remove it from SQL Server. Detach removes the database from SQL Server so that the files are released.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-30 : 17:03:25
|
| Detach completely removes the database from the server, it is no longer listed in the server's list of databases, as far as the server is concerned the database no longer exists. Take Offline is similar in the sense that the database is not available to any users (not even sysadmin), the server closes it completely, but it doesn't remove it from the server's list of databases.For example, run SELECT * FROM sysdatabasesbefore and after taking a database offline and detaching. |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2007-03-30 : 17:15:20
|
| Thank you guys! I liked select * from sysdatabases; cleared my doubt.------------------------I think, therefore I am - Rene Descartes |
|
|
|
|
|
|
Deatch and Takeofline