Posted by Stu on 09/26/05 00:03

Having just recently begun to g othrough log shipping processes myselg,
I think I understand what you're asking: you want to know how big will
the individual log files be (on average) during the log shipping
process, correct? You don't have to actually ship these files to find
out, but you will need to implement a transaction log plan that backs
up your transaction log every 15 minutes.

Use the Maintenance Plan wizard, and without implementing log shipping,
set up a plan that backs up your transaction logs. This can be safely
implemented on a production server, assuming that you don't already
have a backup plan in place that relies on transaction logs for
point-in-time restoration; if you do, then you should already have
method of answering this question. :)

Be sure that your database recovery mode is set to FULL.

HTH,
Stu

[Back to original message]