Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CCC Database Full

Status
Not open for further replies.

jml2665

Vendor
Joined
Mar 8, 2005
Messages
828
Location
GB
my customers been running great for two years, now I find that the CCC reporter is failing and I believe it's because the DB is full, at 2gb. I have asked our supplier but they have not got back to me yet, I asked what to do to clear out old records. I've backed up the DB but I can't see how to purge so I can reduce the size.
Have I missed a parameter somewhere in the CCC services? Anyone know how to purge or maybe do I need to start a new DB file?
 
It turns out that if you have the licensed MS SQL tools you can read the sdxarchiver database and trim out any of the records you choose to. Otherwise that you will have to start over with a new database. It is the free database after all.
 
one of the supervisor options is to "grow" the database. Not sure where the 2gb limit came from but can you use the grow options?
 
I thought the grow option was only for the full SQL database not for MSDE.
What database engine are you running. If you are running SQLServer the initial setup of CCC installs a database of 2Gb.
 
MSDE is limited to 2 Gb in the software and cannot be increased, a full SQL 2000 database can be increased using the database management tools.

If you have MSDE you still can use the SQL 2000 management tools, make a backup and clear the database. Knowledge of SQL is required.
Also you can make a backup and reinstall the reporting server, it will ask to create a new database, say yes and a fresh database will be created.
 
thanks all, that's what I am doing though I was asked (well told sort of) to upgrade to the latest CCC, which I will do. They said this will fix the database purging issues that caused all this in the first place.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top