Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    62

    Unanswered: log file backup frequency

    Helllo,

    How can I know how many transactions are saved in a transaction log backup? Is there a way to compute transaction log backup frequency?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Transaction log backups are scheduled events, and how often you schedule them depends upon the recoverability and restorability you require. How many transactions are stored depends upon how many occured since the last log backup. Could be 1, could 1,000,000. You will need to read up in Books Online to decide what is best for you, but in the mean time use the maintenance plan wizard to set something up.

    blindman

Posting Permissions

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