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 file
only.
Kindly guide me.
Amit
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
|||Try Tom's suggestion first but if that doesn't work you can have a look
here:
http://www.sqlservercentral.com/scri...p?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
>