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?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
No comments:
Post a Comment