Hi there,
I lost my .LDF file. Is there a possibility to recover Database from the MDF file with all data and Stored procedures?
Im using SQL Server 2000.
Please help....and sry if this is the wrong Forum for it...
Thx T. Gnewuch
Can you explain what you mean by losing the .ldf file?
Do you have your databases backed up regularly. If so, you can recover your database from the latest backup.
|||Try to use sp_attach_single_file_db, it can recreate the logfile if the database is not corrupt.HTH, Jens Suessmeyer.
http://www.sqlserver205.de
|||thx , that solved my problem, everything is working fine now again ;)
No comments:
Post a Comment