How can I ensure that a checkpoint has occurred and
committed transactions are written to the database.
If I stop the database service and take a offline backup of
db file, does a checkpoint occur while the service is being
stopped so that the backup is complete and .db file contains
all the records that are there in the .log file.

Yes - if you stop the server, an implicit checkpoint is performed.

You can manually trigger a checkpoint by issuing a CHECKPOINT statement
(eg. from DBISQL).

Glenn

Deepali wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Thank You for replying Glenn..

That means if I rebuild this .db file after I stop the
database service and take an offline backup of .db file,
then I do not need to worry about the old transaction log as
they do not need to be applied to the .db file after rebuild
and the new .db file has complete transactions as rebuilding
will start a fresh transaction log.

Does that mean that no transactions are left out if I
rebuild.

thanks again, Deepali

Thank You So much for replying Mark, Glenn....

regards, Deepali