Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesHaving 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
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread