SQL Maintance plan

Guest · Post by **Guest** » Tue May 17, 2005 11:11 am

I am using SQL 2000 standard edition to host my databases on, and am having trouble using enterprise manager to schedule a maintance plan created just for the sgvault table. I am also having the same issue with the dragnet database also.

I made sure the user rights for the backup user is the same as all the other databases that use similar plans. The only change I have made to the database is I changed the recovery mode to full to create transaction log backups. Everytime I try and run the job from SQL server agent the job fails? Anyone have an idea what I am doing wrong? I am backing up 25 other databases the exact same way and don't have any issues. I can log into query analyser as that user and run a database backup to the same directory with out any issues.

Thanks

Post by **jclausius** » Tue May 17, 2005 11:28 am

Dragnet 1.0.x and Vault 3.0.2 and above both use 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.