Sunday, February 12, 2012

attaching a database without a log file

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"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