Is there a SQL Server API to flush all buffers to disk?

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?"SK" <sriharik@.hotmail.com> wrote in message
news:5c9e9c28.0309032019.43b6050b@.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?|||Look for CKECKPOINT command in BOL

"SK" <sriharik@.hotmail.com> a crit dans le message de news:
5c9e9c28.0309032019.43b6050b@.posting.google.com...
> 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?|||"Greg D. Moore \(Strider\)" <mooregr@.greenms.com> wrote in message news:<lEz5b.34219$yG2.18169@.twister.nyroc.rr.com>...
> "SK" <sriharik@.hotmail.com> wrote in message
> news:5c9e9c28.0309032019.43b6050b@.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?|||"SK" <sriharik@.hotmail.com> wrote in message
news:5c9e9c28.0309041725.6ad6a1d5@.posting.google.c om...
> "Greg D. Moore \(Strider\)" <mooregr@.greenms.com> wrote in message
news:<lEz5b.34219$yG2.18169@.twister.nyroc.rr.com>...
> > "SK" <sriharik@.hotmail.com> wrote in message
> > news:5c9e9c28.0309032019.43b6050b@.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.|||SK (sriharik@.hotmail.com) writes:
> "Greg D. Moore \(Strider\)" <mooregr@.greenms.com> wrote in message
news:<lEz5b.34219$yG2.18169@.twister.nyroc.rr.com>...
>> "SK" <sriharik@.hotmail.com> wrote in message
>> news:5c9e9c28.0309032019.43b6050b@.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,

In SQL Server parlance CHECKPOINT is a process where SQL Server writes
all updated data pages to disk. This happens automatically about once
a minute, or if you request it with the CHECKPOINT command.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp