dbcc dbreindex

Last Post 15 Jan 2009 12:03 PM by dbandee. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
dbandee
New Member
New Member

--
15 Jan 2009 12:03 PM
Happy new year everyone!!!

I inherited some db maint jobs
One is reindexing

and it run sproc with 750 lines of dbcc code. one for each table

dbcc dbreindex (table1)
dbcc dbreindex (table2)
dbcc dbreindex (table3)
dbcc dbreindex (table4)

our tlog is gowing to 60GB everytime this job runs

I added log backup command every 100 lines or so

is there a better way to acomplish this

reindex all tables and keep log under control

Thanks


Acceptable Use Policy
---