SQL 2000 database recovery

5 pts.
Tags:
SQL 2000
SQL 2000 recovery
SQL Database
SQL Server 2000
SQL Server 2000 Database
Hi, weve had an issue with a raid array meaning our sql 2000 cluster wont start. Weve recovered data to another server using backups, however were missing that days data as the backups hadnt started for that day and we have no tran log backups between those times. I have the original mdf and ldf files. My assumptionw as that if I attach those files to a new database that I would have up to date data to the point of the raid failure. However when I look at the data theres several years missing. The timestamps of the mdfs and ldfs are correct but the data is very old. Can anyone advise or suggest what Im doing wrong please?
ASKED: February 22, 2011  1:48 PM
UPDATED: September 29, 2011  10:03 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

If you have the mdf and ldf files that were attached to the failed SQL Server those should have all the data within them. If they don’t, then you don’t have the correct files. Sounds like you had a couple of different databases attached to the instance, one of which had the production data in it, and one which didn’t.

If you can’t find those files (or if they were lost) you’ll need to go to the backups that you have, and accept the loss of a days worth of data.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • MattPoirier
    Keep in mind that if the database was renamed at some point, the mdf and ldf files could still have their original names. As MrDenny says, you might not have the correct files.
    15 pointsBadges:
    report
  • Yorkshireman
    Just being flippant - Can anyone advise or suggest what Im doing wrong please? the irish answer is that "if you want to recover from SQL 2000 you would be needin' to be usin' DB2 on reliable hardware. " But seriously, not funny, Even in a world of duplicated iron, high availablity, rigorous system journalling and backups, retoring is still abit of a black art
    5,520 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following