SQL Server 7/DBCC DBREINDEX

• gts31

  Ten Centuries

  Points: 1294

  More actions

  January 23, 2007 at 10:46 am

  #63035

  I have a SQL Server 7 database with SELECT INTO/BULK COPY turned on. At times I am getting an error backing up the log because of nonlogged updates that have occurred on the database. I cannot find any jobs/stored procs/dts packages that are doing nonlogged operations.

  The error messages seem to correspond more or less to after a defrag job has run (using DBREINDEX). Would DBCC DBREINDEX be considered a nonlogged update? I can't find any documentation that says it is or isn't nonlogged.

  Thanks,

  George

• dclark

  SSC Eights!

  Points: 843

  More actions

  January 23, 2007 at 11:56 am

  #685019

  If you want to do transaction log backups, turn off the SELECT INTO/BULK COPY option.

   

   

• gts31

  Ten Centuries

  Points: 1294

  More actions

  January 23, 2007 at 12:11 pm

  #685024

  I am looking into turning this option off. I am not sure why they have it turned on in the first place. In the meantime I am trying to track down what is doing the nonlogged updates. I suspect that is is the reindexing job but am not certain.

  Thanks for the reply!

  George