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

Restoring database

P: n/a
Hello,
due to some testing my SQL Server crashed. I have to reinstall it and ...
For now I only have .mdf file and nothing else. My question is: is there any
possibility to restore this .mdf file for SQL 2000? I have some useful data
in this file and there will be nice to use it.

Best Regards
MarciN
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a

"Snick" <bu*****@gold.pl> wrote in message
news:bt**********@news2.ipartners.pl...
Hello,
due to some testing my SQL Server crashed. I have to reinstall it and ...
For now I only have .mdf file and nothing else. My question is: is there any possibility to restore this .mdf file for SQL 2000? I have some useful data in this file and there will be nice to use it.

Best Regards
MarciN


You can try using sp_attach_single_file_db, but this may not work (it is
supported only for databases detached with sp_detach_db). If it doesn't
work, then you should consider contacting MS PSS, if the data is valuable
enough.

Simon
Jul 20 '05 #2

P: n/a
Snick (bu*****@gold.pl) writes:
due to some testing my SQL Server crashed. I have to reinstall it and
... For now I only have .mdf file and nothing else. My question is: is
there any possibility to restore this .mdf file for SQL 2000? I have
some useful data in this file and there will be nice to use it.


Beyond the sp_attach_single_file_db, there is a way to do this. However,
this is a dangerous path to go, and I am only sending the instructions
by mail. And if that data is very dear to you, you should definitely
cough up the money for a support case. (And learn the lesson and start
to take backups!)

It is dangerous, because you build a new clean log file, and you get
the database exactly in the state of the crash. If the database was
idle, it may be perfectly fine. If there was activity, it may be
grossly corrupt. DBCC may or may not reveal anything, but your own
data could be consistent.

--
Erland Sommarskog, SQL Server MVP, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.