On Tue, May 26, 2009 at 11:46 AM, Matt Jarvis <[email protected]> wrote: > On our live system, in Enterprise Manager if I right click on a DB, > properties, then look at 'Data Files' and 'Transaction Log', I see > references to filenames at a given disk location. Great.... > > I go to that location and sure enough the files are there, but the > timestamps are from 5/15/09 5:06pm. This is our LIVE data that we hammer > on all day long... > > I thought that perhaps the transaction log would be carrying all the > changes since 5/15, but looking at its' timestamp it is dated 5/15 as > well. > > I'm stumped... am I looking at my data or not?? --------------------------------
You are! You are confusing the growth phase of the file with the interactions taking place within that file. As a heads up why would you want the OS to keep updating the file timedate stamp for thousands of transactions per second that could be happening within your db? Things to look at are the db size, free space in the db and what the autogrowth setting is currently. I have a 980 gb db that spans 5 files. One is meta data for the system, we use 2 for customer data, another is indexes, and then the logs. So I can position all of those files on various spindles to increase performance when we access and write data. I have auto growth set for 75 gig so any time I get close the file system will be asked to carve out another 75 gig of space for my need. This is when the timedate stamp is effected. -- Stephen Russell Sr. Production Systems Programmer Web and Windows Development Independent Contractor Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
