Is there any way to retrieve an mdf and ldf from an sql server 7
installation when they have not been firstly detached?

Thanks.

Report this post to a moderator

Sure, if SQL Server was stopped at the time the MDF/LDF were grabbed. The
documentation talks about a proper "detach", but if SQL Server is stopped,
things seem to work fine too. If SQL Server was up, and you just copied the
MDF/LDF you'll just have to try the re-attach and see whether you get lucky.
Or, if the SQL Server box crashed and now all you have is the MDF/LDF you
might get lucky. If for some reason you have trouble attaching the LDF, you
could try sp_attach_db_single_file and have SQL Server recreate an new LDF
for you. Certainly you will lose the the log information, but that might be
better than the alternative.

Obviously, a backup would be much better.

James


"News Hound" <me@home.com> wrote in message
news:uU0FKqKlCHA.1368@tkmsftngp09...
> Is there any way to retrieve an mdf and ldf from an sql server 7
> installation when they have not been firstly detached?
>
> Thanks.
>
>

Report this post to a moderator