Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detach or take database offline task question

Status
Not open for further replies.

katekis

MIS
Feb 12, 2009
66
US
We have a few databases that are no longer in use. I want to disable the databases and then eventally get rid of them.

Can someone point me to documentation on the task "Take offline" and also the task "Detatch".

Thanks,
 
Look in the Books OnLine (Start>All Programs>Microsoft SQL Server>Documentation. Use the Index search.

For Detaching, look up DetachDB or sp_detachdb

For Take Offline, look up offline database and then click on the option for Setting Database Options.

While those entries show you how to do it in TSQL, they also explain what is happening.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top