By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,419 Members | 1,636 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,419 IT Pros & Developers. It's quick & easy.

database recovery

P: n/a
WH
Hi,
I'm no where close to a SQL Server expert but we're using it as a back end
to another application.

I lost a PC that had MS SQL Server 2000. I was able to recover the .MDF and
..LDF files but nothing else. How can I restore these files to another SQL
Server installation on another PC. When I tried to attach them they are not
recognized as valid files (I get the red X instead of the green CHECK).

Is this a basic security function that I'm not going to get around or should
it be possible? Do the .mdf and .ldf files contain specific info about what
PC they were created on?

Are there third party apps that might be able to at least extract the
tables?

Thanks,
WH
Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi

Try attaching them using from Query Analyser using the sp_attach_db stored
procedure (see Books online)
EXEC sp_attach_db @dbname = N'pubs',
@filename1 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs.mdf',
@filename2 = N'c:\Program Files\Microsoft SQL
Server\MSSQL\Data\pubs_log.ldf'If that fails you may have to resort to your
database backups.John"WH" <us**@server.com> wrote in message
news:IJ******************@twister.rdc-kc.rr.com...
Hi,
I'm no where close to a SQL Server expert but we're using it as a back end
to another application.

I lost a PC that had MS SQL Server 2000. I was able to recover the .MDF
and
.LDF files but nothing else. How can I restore these files to another SQL
Server installation on another PC. When I tried to attach them they are
not
recognized as valid files (I get the red X instead of the green CHECK).

Is this a basic security function that I'm not going to get around or
should
it be possible? Do the .mdf and .ldf files contain specific info about
what
PC they were created on?

Are there third party apps that might be able to at least extract the
tables?

Thanks,
WH

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.