Microsoft SQL Server forum - Re: Is there a way to find growth in log (ldf) and database(mdf) ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Re: Is there a way to find growth in log (ldf) and database(mdf) ?

Stu

2005-09-25, 8:23 pm

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

Sponsored Links