Jonathan Kehayias (5/27/2009)

---

You should use CREATE DATABASE [databasename] FOR ATTACH as shown in the quote from the Books Online. This has a much more verbose syntax and allows for the options needed to be configured while the database is created to include, who the owner should be, one of the other problems listed in the comments here.

GRE (5/27/2009)

---

Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will that remain?

David Benoit (5/27/2009)

---

...and there is a great script for this HERE

jboc (5/27/2009)

---

On occasion a log file will fill up to the problem point and we could use detach/attach to delete the old log and start over. Not something that we would normally want to do but something that was an option in an emergency. Is there a simple way to do that once detach/attach goes away?

David Benoit (5/27/2009)

---

...and there is a great script for this HERE

GRE (5/27/2009)
--------------------------------------------------------------------------------
Have i missed a trick here? I understand that the old way to attach a database is be depreciated, But is SP_Detach_DB bein decreciated too? or will that remain?

Yes, both the attach and detach stored procedures are deprecated, here is the page for sp_detach_db from Books Online (see the Important box just after the syntax section):

http://msdn.microsoft.com/en-us/library/ms188031.aspx

Noel McKinney (5/27/2009)

---

Yes, both the attach and detach stored procedures are deprecated, here is the page for sp_detach_db from Books Online (see the Important box just after the syntax section):

http://msdn.microsoft.com/en-us/library/ms188031.aspx

Jonathan Kehayias (5/27/2009)

---

This should never be used as an option. It is essentially ripping the transactional heart out of your database. Despite being successful doing this numerous times in the past, it only takes once for the disasterous effects of doing this to ruin your day, job, career when the database fails to attach without its log.

I'd recommend reading Paul Randal's article:

http://technet.microsoft.com/en-us/magazine/cc895648.aspx

and his blog posts on the Transaction Log:

http://sqlskills.com/BLOGS/PAUL/category/Transaction-Log.aspx

Specifically:

http://sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-EMERGENCY-mode-repair-the-very-very-last-resort.aspx
http://sqlskills.com/BLOGS/PAUL/post/BACKUP-LOG-WITH-NO_LOG-use-abuse-and-undocumented-trace-flags-to-stop-it.aspx

When you attach without the log file, it is rebuilt, which can leave your database incosistent, not a good thing to do.