SQL Server Performance Forum – Threads Archive

reload

Hai folks, Unfortunately, I lose the database named TDP. Luckily,I left with the .mdf file called .tdp_data.mdf, but, without any log(.ldf) file. sp_attach_db is not functioning without .ldf file. How to restore the database without .ldf file. Pl. expedite to do needful. Rajendar ok

Hi Rajendar,

quote:
How to restore the database without .ldf file.

mabye sp_attach_single_file_db will help you! Cheers,
Frank

sp_attach_single_file_db is also not working.
Rajendar ok

Ref the question i lost log file under general dba questions. Thanks. Rushendra

Make sure the .MDF file has been detached properly earlier.
Refer to this thread http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=1124] under this forum (as mentioned by Rushi).
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

once i’ve copied and pasted the .mdf file. That file i’ve. with that file how’d i reload database.
Rajendar ok

Once you reset the status and rebuild the log, you would be able to see the data. If you use SP_ATTACH_SINGLE_FILE_DB to attach the database, once the attachment is successfull the data is visible. _________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>