Difference between Detach and Database off-line

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Difference between Detach and Database off-line

Author

Topic

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2013-10-03 : 09:22:48

I am trying to understand the difference between Detaching a Database and Taking it off-line.

The only thing I can think of is that Taking it Off-Line is easier to bring it on-line, it is just a single click rather than having to find the files.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources