469,111 Members | 1,993 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,111 developers. It's quick & easy.

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

SK
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?
Jul 20 '05 #1
5 5944

"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?
Jul 20 '05 #2
M.B
Look for CKECKPOINT command in BOL

"SK" <sr******@hotmail.com> a écrit dans le message de news:
5c**************************@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?

Jul 20 '05 #3
SK
"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?
Jul 20 '05 #4

"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.

Jul 20 '05 #5
SK (sr******@hotmail.com) writes:
"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,


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, so****@algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 20 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by 11abacus | last post: by
3 posts views Thread by JnlSeb | last post: by
3 posts views Thread by Georgios Sakalis | last post: by
10 posts views Thread by Peter Larsen [] | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by kglaser89 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.