Attaching a Database

Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF fil
e
only.
Kindly guide me.
AmitCheck out sp_attach_single_file_db in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
Hi Friends
Can i attach a database without having its LOG file. Unfortunately all LOG
backups and original log files are deleted from the server. I've the MDF
file
only.
Kindly guide me.
Amit|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scr...sp?scriptid=599
Andrew J. Kelly SQL MVP
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:%23%23J1x%23$7EHA.3708@.TK2MSFTNGP14.phx.gbl...
> Check out sp_attach_single_file_db in the BOL.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Columnist, SQL Server Professional
> Toronto, ON Canada
> www.pinnaclepublishing.com
> .
> "Amit-SQL-DBA" <AmitSQLDBA@.discussions.microsoft.com> wrote in message
> news:4281944D-1714-4A69-8664-BFFACEC4649B@.microsoft.com...
> Hi Friends
> Can i attach a database without having its LOG file. Unfortunately all LOG
> backups and original log files are deleted from the server. I've the MDF
> file
> only.
> Kindly guide me.
> Amit
>