Feb 12, 2010 #1 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,
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,
Feb 12, 2010 #2 SQLBill MIS May 29, 2001 7,777 US 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 Upvote 0 Downvote
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