Changing backup model before running reindex

Our txn log is ballooning after we re-index. I've see a recommendataion to
change to Bulk-logged before re-indexing and I'm wandering, will this break
my backup chain? Currently we are running full backups every Sun morning
and re-indexing Mon and Thurs.
Thanks.Are you doing log backups? If not, go to simple recovery model.
If you are doing log backup, then changing to bulk-logged will produce less
records in the ldf file,
but the following log backup can potentially be larger than if in full recov
ery. It will not
adversely affect your backup strategy, but two things to remember are:
If you have performed a bulk-logged operation, then you can't restore a log
backup to point-in time.
If db is in bulk-logged mode, you won't be able to backup log if a data file
crashes.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Kevin" <none@.none.com> wrote in message news:6D4D3721-2B84-4AC7-B19C-7307EC729604@.microsoft
.com...
> Our txn log is ballooning after we re-index. I've see a recommendataion t
o change to Bulk-logged
> before re-indexing and I'm wandering, will this break my backup chain? Cu
rrently we are running
> full backups every Sun morning and re-indexing Mon and Thurs.
> Thanks.|||Addition to Tibor's comment: Take backup before and after changing your
Recovery Model to SIMPLE\BULK LOGGED for indexing operations.
Ekrem nsoy
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:8BF808EA-D953-4467-83BD-3CDC59691BC7@.microsoft.com...
> Are you doing log backups? If not, go to simple recovery model.
> If you are doing log backup, then changing to bulk-logged will produce
> less records in the ldf file, but the following log backup can potentially
> be larger than if in full recovery. It will not adversely affect your
> backup strategy, but two things to remember are:
> If you have performed a bulk-logged operation, then you can't restore a
> log backup to point-in time.
> If db is in bulk-logged mode, you won't be able to backup log if a data
> file crashes.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "Kevin" <none@.none.com> wrote in message
> news:6D4D3721-2B84-4AC7-B19C-7307EC729604@.microsoft.com...
>