February 8, 2006 at 8:20 am
OK, we have two servers. Both SQL 7 on Windows 2000.
SQLSRV1 is the main production server where all the data is written, e:\sqldata\data
SQLSRV2 is a standby server that has mirroring software running on it for a 'warm' server failover option. If mirrors the DATA folder of the databases. The mirroring software has open file options, etc.
We set this up and we noticed that no data was being sent over the mirrored connection. When we checked the modified date of the databases on SRV1, they were days old. But when you check inside the databases on SRV1, the data is all there up to the minute that you query it. Why would the data be 'up-to'the-minute', but the modify date is days old? Then suddenly a bunch of the databases will show a newer modified date? If widows does not show a new date, then the mirroring software never updates?
Do I have a setting wrong?
February 8, 2006 at 10:51 am
As long the database doesn't change in size (have to check this theory) or is not closed the modified attribute isn't been set (otherwise each write command would cause the modified attributed to be set)
February 8, 2006 at 11:35 am
If that is true, how can I have it set teh modified attribute to be set everytime there is ANY data that is being set, changed, etc.
Changing the file size should have nothing to do with it, as that is not he only criteria to modifying a file, as far as I know.
February 9, 2006 at 10:09 am
I don't know (perhaps detaching/attaching the database)
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply