Results 1 to 4 of 4

Thread: Checkpoint

  1. 08-26-2003, 04:33 AM #1
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142

    Checkpoint

    Please help.

    I would like to checkpoint my transaction log every night before full backup.
    Would this affect the transaction log sequence in the event of a restore.

    I run SQL Server 2K SP 3 on WIN 2K SP 3.

    Thank you.


    Regards
    Reply With Quote Reply With Quote
  2. 08-26-2003, 08:12 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Day 1
    a1. full backup 10 pm
    a2. tran backup 11 pm
    a3. tran backup 12 am
    a4. ........ (goes on until next day 9pm)
    a5. Checkpoint 10 pm
    a6. Full backup 10:30 pm
    a7. tran backup 11 pm
    a8. tran backup 12 am
    a9. tran backup 1 am

    in this case only the backups from
    a6 to a9 can be restored sequentially and not from a1 to a9.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 08-26-2003, 10:03 AM #3
    olutimi
    olutimi is offline Registered User
    Join Date
    Jul 2003
    Posts
    142
    Thanks mak.

    I would apply the solution later.

    Regards

    What is the impact of enabling SQL Auditing?.
    Reply With Quote Reply With Quote
  4. 08-26-2003, 11:13 AM #4
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    It is running smoothly for us for the past 2 yrs.
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules