"SK" <sr******@hotmail.com> wrote in message
news:5c**************************@posting.google.c om...
"Greg D. Moore \(Strider\)" <mo*****@greenms.com> wrote in message
news:<lE*******************@twister.nyroc.rr.com>. ..
"SK" <sr******@hotmail.com> wrote in message
news:5c**************************@posting.google.c om... I am looking for an API to flush all data in memory held by SQL Server
to disk. Also, is there a tool for SQL Server like eseutil for
Exchange that lets you correct a SQL database?
What do you mean by "correct"
And DBCC DROPCLEANBUFFERS may be something you're looking for.
Otherwise not sure what you mean by flush buffers to disk?
Or do you mean Checkpoint?
Well, if I asynchronously replicate (note that there is no
checkpointing in async replication) a SQL Server database, to bring up
the replicated copy of SQL Server, is there a utility that will help
me verify the integrity of the database and correct any "correctable"
portions of the database. eseutil does this for the Exchange JET
database format. Is there an equivalent tool for SQL Server?
I'm not sure what you mean exactly by asynchronously replicate the database?
Do you mean the transactional replication that SQL Server does, or log
shipping or what?
Unless you use clustering, any failover solution will be necessarily
slightly behind the original live DB.
As for verifying the integrity, DBCC CHECKDB will do that. But I don't
think that's what you mean here.
If you mean making sure non-committed transactions are rolled forward or
backward as appropriate, depending on what you're doing, that's basically
done automatically.
Keep in mind, unlike JET, SQL Server is designed from the ground up to be
ACID compliant.
I'd also at this point recommend Kalen Delany's Inside SQL Server 2000 as a
good starting point.
