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!
-
-
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. -
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...
-StewartComment
-
I'm thinking MDF is actually a SQL Server database file Stewart - rather than anything to do with Access.Comment
-
MDF is SQL Server, MDB is Access.
@TS: I'll send some flowers to your funeral...
StevenComment
-
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!
-SComment
-
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 :DComment
Comment