Sunday, February 12, 2012

backing up transaction logs

Hi,
I would like to know if it is really nessary to backup the transaction logs
if their size is above 10 gigabytes. Is it not better to backup only the
database, delete the current log and then re-create the log.
If so, can someone help me with a scheduled script to do this?
Thnx
Hi
Check out
http://msdn.microsoft.com/library/de...r_da2_1uzr.asp
http://msdn.microsoft.com/library/de...r_da2_7vaf.asp
Deleting the log file as you have suggested would mean that the database is
not available during that period of time.
Your log file should be sized appropriately so that it does not continuously
grow, if you re-create a log file that is too small then you may affect
performance.
John
"Jason" <jasonlewis@.hotrmail.com> wrote in message
news:O$kKVGDEFHA.3032@.TK2MSFTNGP12.phx.gbl...
> Hi,
> I would like to know if it is really nessary to backup the transaction
> logs
> if their size is above 10 gigabytes. Is it not better to backup only the
> database, delete the current log and then re-create the log.
> If so, can someone help me with a scheduled script to do this?
>
> Thnx
>
|||Jason
If you don't want to use your transaction log for recovery purposes, set
your database to simple recovery mode. Then your transaction log will be
truncated every time a checkpoint is issued.
Regards
John
"John Bell" wrote:

> Hi
> Check out
> http://msdn.microsoft.com/library/de...r_da2_1uzr.asp
> http://msdn.microsoft.com/library/de...r_da2_7vaf.asp
> Deleting the log file as you have suggested would mean that the database is
> not available during that period of time.
> Your log file should be sized appropriately so that it does not continuously
> grow, if you re-create a log file that is too small then you may affect
> performance.
> John
> "Jason" <jasonlewis@.hotrmail.com> wrote in message
> news:O$kKVGDEFHA.3032@.TK2MSFTNGP12.phx.gbl...
>
>

No comments:

Post a Comment