Post reply

SQL Server 7/DBCC DBREINDEX

  • 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

  • January 23, 2007 at 11:56 am

    #685019

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

     

     

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply