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

missing records in mdf file

100+
P: 107
i recently formatted my pc where sql server 2000 was installed. I backed up my db and then restored it after formatting. But today i came to know that all the recent records are lost (may be because i didnt backed it up well). So, i went back to the original files by recovering it using a recovery software. i got the mdf and ldf file for the database. Then i attached the mdf file to my new database. Still i find the records missing. I suppose the mdf would have my recent records even if i didnt back up well. But I am surprised that the datas are missing. So, anybody would be kind enough to help me on this issue. Its very urgent .... if i dont find a way out, my boss gonna kill me. Please help me!
Aug 16 '10 #1
Share this Question
Share on Google+
6 Replies

NeoPa
Expert Mod 15k+
P: 31,770
I recommend that you wear a stab-resistant vest to work tomorrow.

It sounds as if the backup was flawed and the data is not available. It may be that the corruption (or error or whatever the problem was) occurred before the backup was run. Maybe you ran the backup before the data was available. I don't know.

If the data isn't there though, that would indicate to me that the backup didn't catch it for some reason.
Aug 16 '10 #2

Expert Mod 2.5K+
P: 2,545
You mention SQL Server 2000. If you were connected to SQL Server tables it is the SQL Server database you would need to restore from backup, as the data is not in the Access MDF file - only the connection to the tables is present, not the records. It doesn't sound like you took a SQL Server backup before reformatting your disk, so wear a thick vest indeed...

-Stewart
Aug 16 '10 #3

NeoPa
Expert Mod 15k+
P: 31,770
I'm thinking MDF is actually a SQL Server database file Stewart - rather than anything to do with Access.
Aug 16 '10 #4

MrMancunian
Expert 100+
P: 569
MDF is SQL Server, MDB is Access.

@TS: I'll send some flowers to your funeral...

Steven
Aug 17 '10 #5

Expert Mod 2.5K+
P: 2,545
Jeez,I saw MDF and read MDB... Och well, I guess at times we all see what we want to see and not what is really there!

-S
Aug 17 '10 #6

NeoPa
Expert Mod 15k+
P: 31,770
No big deal Stewart. We won't say anything, and the OP won't be saying much after his boss catches up with him anyway :D
Aug 17 '10 #7

Post your reply

Sign in to post your reply or Sign up for a free account.