When does the mdb get updated?

[gcole]

I have a SQL database that is in constant use(table records changed or updated). It appears that it is only updating the mdb file once a day. This doesn't seem right. Any suggestions?

 

[SQLBill]

Why do you think it's only updating it once a day?

-SQLBill

 

[gcole]

By looking at the date modified in explorer.

 

[ecobb]

That actually doesn't have anything to do with the information going in your database. I have a database that gets hundreds of entries per day and Explorer shows it last modified as 3 days ago.



Hope This Helps!

Ecobb

"Alright Brain, you don't like me, and I don't like you. But lets just do this, and I can get back to killing you with beer." - Homer Simpson

 

[SQLBill]

I don't know what causes the modification dates to change, but I don't trust them much. My main database shows the log file (.ldf) was last modified in Dec 2003. One table in my database gets over 250,000 new rows each day. And the log gets lots of use.

-SQLBill

 

[gcole]

Thanks, that helps. I couldn't believe that it wasn't being updated but I needed to check it out. Another problem we are having is that the software (3rd party) doesn't seem to be disconnecting the users when they are out. They are left sleeping for hours. I've asked the dba to select the "Disconnect on Commit" in the database properties. Do you think this will do it, or is there something else I can do?

 

[SQLBill]

That could do it, but what if a user runs a script that has several COMMITs in it?

I suggest setting the server to AUTO-CLOSE.

On checking the update of your database. To be absolutely sure, you can run sp_spaceused. Check out the Books OnLine for more information, but that will show how your files are growing. Run it a couple times a day and you can create a baseline as to how fast your database grows.

-SQLBill

 

[fluteplr]

My best guess is that sql server bypasses the normal file system and that the only time the datestamps get changed is when the file size changes.