473,418 Members | 1,757 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,418 software developers and data experts.

missing records in mdf file

107 100+
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
6 2253
NeoPa
32,556 Expert Mod 16PB
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
Stewart Ross
2,545 Expert Mod 2GB
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
32,556 Expert Mod 16PB
I'm thinking MDF is actually a SQL Server database file Stewart - rather than anything to do with Access.
Aug 16 '10 #4
MrMancunian
569 Expert 512MB
MDF is SQL Server, MDB is Access.

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

Steven
Aug 17 '10 #5
Stewart Ross
2,545 Expert Mod 2GB
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
32,556 Expert Mod 16PB
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

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

Similar topics

0
by: Jonathan de Boyne Pollard | last post by:
J> It's implementation specific Only inasmuch as the implementation determines what "can be processed by the implementation" means. However, a source file that _does not exist_ is going to be...
1
by: DF | last post by:
Hello, We have a query which returns ~2.8 million rows. This same query is used in a DTS package, which exports to a text file. The number of rows in this text file, however, is ~2.7 million...
13
by: Paul Gorodyansky | last post by:
Hi, Could not find the answer neither in FAQs not on the Web... On many javaScript 'tips' sites they say that do warn the user regarding missing .JS file one should do the following: <html>...
3
by: John Duchowski | last post by:
I've got a fairly large Access file with 4899 records. The ID field runs sequentially but misses two rows: it skips 3727 and 3740. Consequently, the dbase indicates that I have 4901 rows where in...
1
by: RobMea | last post by:
I am trying to find a solution to the following problem. First off I'm new to Access and SQL but have a good back ground in other languages, thus at a new job this has just been dumped on me so...
13
by: Jan | last post by:
Hi I have a database that I use to keep track of the sales promotions that we send to companies. I normally send a mailing based on a subset of the companies in the database (found using the...
1
by: shalini0702 | last post by:
Hi, I have Missing Records when exporing a table from (msaccess) One database to another. Supppose My Db has 10 tables and expoting all the table from One database to another was correct. ...
5
by: Neil | last post by:
I'm running Access 2000 with a SQL 7 back end, using ODBC linked tables in an MDB file. The db is used by about 30 users on a LAN, and an additional 10 or so on a WAN. Recently, one of the WAN...
2
kcdoell
by: kcdoell | last post by:
Hello: I am trying to create a union query but do not have a lot of experience. Basically I have the below tables: The Tables: Table Name = tblPrior CreditRegIDFK; Number; Foreign Key...
11
by: jennifersalcido | last post by:
Hello All, I am working with two tables that contain inventory data: 1) INVENTORY contains item_number, description, etc. This data is relatively straight-forward, one record per item_number....
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.