Sunday, March 11, 2012

Backup Database ?

Does the backup database command truncate the transaction log to the point
of the backup?
nivek
No
You must backup the log separately.
If you're using Simple Recovery model, use the backup log... with
truncate_only and then dbcc shrinkfile
to release disk back to the OS.
"nivek" <eckart_612@.hotmail.com> wrote in message
news:rI2dnf7GAuFAeqPfRVn-rQ@.centurytel.net...
> Does the backup database command truncate the transaction log to the point
> of the backup?
> --
> nivek
>
>
>

No comments:

Post a Comment