Restore Database from MDF file without LDF

Iam having SQL Database MDF file how can i restore the database without LDF.
Please anyone reply me and this is very very urgent

quote:

---

Originally posted by Shansinn
Iam having SQL Database MDF file how can i restore the database without LDF.Please anyon
e reply me and this is very very urgent

---

|||You can try sp_attach_single_file_db. But that is only guaranteed if you onl
y had one mdf and one
ldf and actually detached the database first.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Shansinn" <Shansinn.1pa7pq@.mail.codecomments.com> wrote in message
news:Shansinn.1pa7pq@.mail.codecomments.com...
> Iam having SQL Database MDF file how can i restore the database without
> LDF.Please anyone reply me and this is very very urgent
>
> --
> Shansinn
> ---
> Posted via http://www.codecomments.com
> ---
>|||Hi
to restore a database LDF is not required
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---
"Shansinn" wrote:

> Iam having SQL Database MDF file how can i restore the database without
> LDF.Please anyone reply me and this is very very urgent
>
> --
> Shansinn
> ---
> Posted via http://www.codecomments.com
> ---
>|||Add on to Tibor, SP_attach_single_file_db may not work if you have not
detached the database (SP_DETACH_DB).
If this process fails restore from a good database backup.
Thanks
Hari
SQL Server MVP
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:uIKoYYGXFHA.2664@.TK2MSFTNGP15.phx.gbl...
> You can try sp_attach_single_file_db. But that is only guaranteed if you
> only had one mdf and one ldf and actually detached the database first.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Shansinn" <Shansinn.1pa7pq@.mail.codecomments.com> wrote in message
> news:Shansinn.1pa7pq@.mail.codecomments.com...
>|||Use stored procedure sp_attach_single_file_db
AMB
"Shansinn" wrote:

> Shansinn wrote:
>
> --
> Shansinn
> ---
> Posted via http://www.codecomments.com
> ---
>