dbcc shrink log file

Hi:
I just want to confirm that do we need to backup the database after using
dbcc shrinkfile(log, )? I read somewhere that it invalidates the log
sequence, therefore, we will not be able to apply transaction logs to last DB
backup. Is it true about shrinking the log file? If it is, when is the good
time for shrinking the log file. Please let me know. Thanks in advance.
Shrinking the log will not invalidate your log sequence. But shrinking
should only be done under extreme circumstances. If you need to keep
shrinking it that is a clear indication it needs to be larger to begin with
and should stay at that size.
Andrew J. Kelly SQL MVP
"Sal" <Sal@.discussions.microsoft.com> wrote in message
news:464BA510-B21A-4463-9D35-F8327FB8AB84@.microsoft.com...
> Hi:
> I just want to confirm that do we need to backup the database after using
> dbcc shrinkfile(log, )? I read somewhere that it invalidates the log
> sequence, therefore, we will not be able to apply transaction logs to last
> DB
> backup. Is it true about shrinking the log file? If it is, when is the
> good
> time for shrinking the log file. Please let me know. Thanks in advance.
|||No, you do not need to take bakcup after shrinking log file.
Andrew J. Kelly wrote:
[vbcol=seagreen]
> Shrinking the log will not invalidate your log sequence. But shrinking
> should only be done under extreme circumstances. If you need to keep
> shrinking it that is a clear indication it needs to be larger to begin with
> and should stay at that size.
> --
> Andrew J. Kelly SQL MVP
>
> "Sal" <Sal@.discussions.microsoft.com> wrote in message
> news:464BA510-B21A-4463-9D35-F8327FB8AB84@.microsoft.com...
|||Thanks Guys
"amish" wrote:

> No, you do not need to take bakcup after shrinking log file.
> Andrew J. Kelly wrote:
>
>
sql