is it possible to attach a database when a log file is missing?
My database had one .MDF file and 2 .LDFs. I lost one of the .LDFs. Is it
possible to recover any data?
Tegie"Tomek Grzegorz" <tgrzegorz@.piaskowski.pl> wrote in message
news:bvj7ob$j75$1@.atlantis.news.tpi.pl...
> Hi
> is it possible to attach a database when a log file is missing?
> My database had one .MDF file and 2 .LDFs. I lost one of the .LDFs. Is it
> possible to recover any data?
> Tegie
Probably not - sp_attach_db requires all the database files, and
sp_attach_single_file_db doesn't support databases with multiple log files.
Assuming you have no backups, and if the data is valuable enough, you might
consider contacting Microsoft PSS to see if they can recover the data for
you.
Simon
No comments:
Post a Comment