| Andrew J. Kelly 2006-03-09, 8:23 pm |
| They are all FULLY LOGGED operations. If your DB is about 15GB in size and
you rebuild all the indexes you will have about 15GB in logs. There is no
need to stop Log backups so you can do FULL backups. In 2000 the Log
backups can not finish until the Full is completed but it does no harm to
leave them running.
--
Andrew J. Kelly SQL MVP
"Dilan A" <dilan.a@youtelus.net> wrote in message
news:5X3Qf.19045$vC4.2195@clgrps12...
> Hi, Noticed that we have a 15gig log backup on our SQL server after the
> log backups were started after a 5 hour pause. Usually the log is backed
> up every 15 minutes but we pause this job between 12 AM and 5 am during
> which we run our full backups etc.
>
> The normal trend is about 2 Gigs and then much smaller files during the 15
> minute cycle.
>
> The only job that I noticed that ran out of the ordinary is the DB
> maintenance task that rebuilt indexes etc.
>
> Is it possible for DB maintenance tasks such as these reorgs to generate
> logged transactions???
>
> Thanks
> Dilan
|