473,387 Members | 1,283 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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 6298

"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: 11abacus | last post by:
Hi all, I wonder if this is possible: I have a script that does things that take time. In the first part of the script it does data checking and other verifications, then comes the long part. I...
3
by: JnlSeb | last post by:
According to Sun's web site, the flush method of the OutputStream object does nothing. So, what does actually happens when you call it? At times I may see different behavior when including it...
1
by: Daniel | last post by:
System.IO.StreamWriter Close or Flush method to shut down the computer in such a way that just part of the file is written? or an empty file is written? Also if the Close or Flush is to a...
1
by: DraguVaso | last post by:
Hi, I want to create a Service that Reads and Write Files, and Insert and Select Data from a Sql Server Database. I did a little test with a small Service that I wanted to write something to...
3
by: Sally Sally | last post by:
I have a very basic question on the two parameters shared buffers and effective cache size. I have read articles on what each is about etc. But I still think I don't quite grasp what these settings...
29
by: lec | last post by:
Hi, I'm observing the following: If I commit the following records 1,2,3,4,5,6,7,8,9,10 to the database and the server hangs, I could lose records 5,6,7,8,9 but record 10 is there. How is this...
3
by: Georgios Sakalis | last post by:
I need some help for proect of mine I am bulding a web server in c To parse the request I am using a char *buffer, with a default size at te begining, If the bytes that been read are equal to...
10
by: Peter Larsen [] | last post by:
Hi, Is is possible to programmatically flush all opened files ?? BR Peter
7
by: David | last post by:
i think i just realized i'm an idiot. again. (not syntactically correct code... just pieces to illustrate) class StateObject { members like socket, receiveBuffer, receiveBufferSize,...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.