SQL Server Performance Forum – Threads Archive

Restoring Database without logfiles?

Hi friends,
I have the data files both primary and secondary. Unfortunately we missed the logfiles. Is there any way to restore the database from the data files without logfiles?
Thanks in advance.

Yes, you can use Enterprise Manager, Databases, all task, attach database.
Find the mdf files and you will see a log file with a X red.
SQL ask you if you want to create a new log file. HTH Luis Martin
Moderator
SQL-Server-Performance.com The views expressed here are those of the author and no one else. There are no warranties as to the reliability or accuracy of anything presented here.

If you’ve .MDF & .NDF without .LDF then use SP_ATTACH_SINGLE_FILE_DB which will recreate a fresh Transaction log (.LDF) file. Refer to books online for the specified SP. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>