SQL 2000 database recovery
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?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 22, 2011 1:48 PM
UPDATED:
September 29, 2011 10:03 AM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
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.
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