Post reply

Checkpoint manually in each database

  • January 12, 2006 at 6:01 am

    #167121

    Folks,

    Just wanted to know the various methods to do 'checkpoint manually in each database.' Please let me know.

    Regards,

    Arul.

    Get busy living ....or get busy dying....

  • January 12, 2006 at 7:33 am

    #614349

    Try the CHECKPOINT command. Not sure if there is another way of manually forcing a checkpoint, other than doing it indirectly by running an ALTER DATABASE statement and changing a database option.

    Hope that helps,

    Karl
    source control for SQL Server

  • January 15, 2006 at 8:57 pm

    #614828

    h!!!,

       Checkpointing a database can be done mannualy by the command sp_configure 'recovery interval' 5

    reconfigure with override

    the above configuration will checkpoint the database at 5 min like this you will be able to customize the database to checkpoint the databse at specified intervals

    regards,

    Vinod

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply