DBCC fails on Vault database

vrapp · Post by **vrapp** » Sun Mar 20, 2005 11:42 pm

It looks like one of the recent versions made changes in the database schema, so now database maintenance fails. Previously, DBCC CHECKDB and index rebuild succeeded. I did not make any changes to the database or to the maintenance plan or its jobs, only installed new version of Vault server. Now:

[2] Database sgvault: Index Rebuild (leaving 10%% free space)...

Rebuilding indexes for table 'tblbackups'
Rebuilding indexes for table 'tblbranchedhistoryitems'
...
Rebuilding indexes for table 'tblfsobjects'
Rebuilding indexes for table 'tblfsobjectshares'
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server]DBCC failed because the following SET options have incorrect settings: 'QUOTED_IDENTIFIER'.

kasti · Post by **kasti** » Mon Mar 21, 2005 7:32 am

You might want to check the following thread:

http://support.sourcegear.com/viewtopic.php?t=3285

Bye,
Herbert.

Post by **jclausius** » Mon Mar 21, 2005 9:29 am

Yes. Vault 3.0.2 started using a computed column in the database tables. Unfortunately, due to a problem in Microsoft's maintenance plan, any scheduled maintenance using the extended stored procedure will not run on these databases.

The work around is to translate the maintenance plan options into DBCC commands. See the Knowledge Base article - Maintenance: Vault/Dragnet database(s) for more information.