There are two Windows2k systems running SQL Server2K.
The database on the first system is in read/write mode with very frequent writes.
and is replicated on the second system using a block level replication engine.
The second system runs SQL Server2K on the replicated Database in read only mode.
(It is not using SQL Server Replication)
Clients are doing transactions and updates to the database on the first SQL
server. Different set of clients are doing transcations (reads only and noupdates
or new transactions) on the 2nd server. While this is happening, in parallel, the
block transfer engine is shipping blocks of new (updated) raw data from the 1st
server to the 2nd server.
Since the SQL server on the 2nd system has no way of knowing that the raw data
on the disk is changing, he always give stale data which is in its buffers. Is there
a way we can flush all the pages and buffers of the database and reread everything
from the cache, without the database going offline, that is while the connections
Thanks in advance.