Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
smsajjad
Starting Member
1 Post |
 Posted - 2005-09-20 : 07:23:18
|
| Hi, From what I know, Any changes in the Table are recorded in the Log Files (LDF) and hence the Modified dates of the MDF and LDF are similar. But here in my case the Modified Date of both the MDF and LDF file are not the same. Infact there is a huge difference in both for my database. MDF : 4th Sept LDF : 16th Sept I have an automated process runnning on my server which keeps inserting records in the above Database table. I fear, my Automated Process has failed for some reason, and would like to know, is there any other reason why the Modified Dates of the MDF and LDF Files are different.... Please help me as my data is critical and I cannot afford to loose anything. Regards S.M.Sajjad |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-20 : 07:40:47
|
| I'm not at all sure what relevance actual modification dates for files have in this regard. Many of mine are all over the shop.I reckon if you stop-start SQL Server the file dates will show a true picture, but I'm not sure they are reliable otherwise.If you are worried about critical data I would suggest you restore a recent backup to a different machine, run a DBCC CHECKDB on it, and check that recent data is present.If that works out correct then Sleep Easy at night!Kristen |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-09-20 : 23:44:21
|
| did you shrink the log file on sept 16?--------------------keeping it simple... |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2005-09-21 : 00:13:15
|
| the dates on LDF/MDF/NDF files only change when their sizes change. If you have enough room in a datafile to add data, the modification date will never change.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-09-21 : 04:49:48
|
| ec - that's my piece of new knowledge for today! Thanks for that.Kristen |
|
|
|
|
|
|
MDF ad LDF Files Date are not the same