Reevaluating and updating dbccdb configuration  Removing workspaces

Chapter 10: Checking Database Consistency

Cleaning up dbccdb

Adaptive Server stores data generated by dbcc checkstorage in dbccdb. You should periodically clean up dbccdb by using sp_dbcc_deletehistory to delete data for the target database that was created before the date you specify.

When you delete a database, you should also delete from dbccdb all configuration information and dbcc checkstorage results related to that database. Use sp_dbcc_deletedb to delete all database information from dbccdb.





Copyright © 2005. Sybase Inc. All rights reserved. Removing workspaces

View this book as PDF