Information générale
Forum:
Microsoft SQL Server
Titre:
Retieveing data from a mdf without the ldf.
We are running SQL Server 2000 and have done a database backup using Veritas. When we restore the backed-up database the Veritas software errors out restoring the log. The data .mdf file appears to be intact ( by size anyway ). I have used sp_attach_single_file_db and get an error that the log file doesn't match the data file. This to me is a contradiction to the purpose of the procedure. I have tried various tricks re: detaching a newly created database of the same structure and copying the .mdf over and re-attaching etc... this also failed My question: Is there anyway to recover the data from my .mdf file without accessing or bypassing the corrupt .ldf , maybe using bcp of something? Note: The database I want remains unattached.
Thanks a bunch.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement