Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Community Member

Historical reports sql database size UCCX 4.5

Good day.A database size of 2048 mbytes by default.May be anybody knows is it possible to increase it?

2 ACCEPTED SOLUTIONS

Accepted Solutions
Bronze

Re: Historical reports sql database size UCCX 4.5

Hi

I think you have MSDE installed on your CRS server, You can check it if you dont have option for SQL enterprise Manager in the menu.

Green

Re: Historical reports sql database size UCCX 4.5

If you have SQL Server installed on another machine, you can add the Microsoft SQL Desktop Engine to the Server Group as another server, assuming they can see each other. That way you can see the database tables on the MSDE machine.

But the other poster is correct - the max size for MS SQL DE is 2GB.

Regards,

Geoff

4 REPLIES
Bronze

Re: Historical reports sql database size UCCX 4.5

Yes, you can increase. If the DB installed is MSDE, then you get a Max Size of 2GB and if it is SQL Server, then the size depends on the Hard Disk capacity (may vary between 10GB to 13GB).

This URL should help you:

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/products_administration_guide09186a00801d6f9c.html

CRA Historical Reporting Problems:

http://www.cisco.com/en/US/products/sw/custcosw/ps1846/prod_troubleshooting_guide_chapter09186a0080193f35.html#1150407

Community Member

Re: Historical reports sql database size UCCX 4.5

Hi.

Thanks a lot for your response.

I'm sorry,but i wasn't able to find any way,how to increase database size.

I've only mssql service on the mashine,but there is no way how to configure it at all...

Neither in @start-programs@,nor in @computer management@

Please,explain me how i can configure the mssql server?

Bronze

Re: Historical reports sql database size UCCX 4.5

Hi

I think you have MSDE installed on your CRS server, You can check it if you dont have option for SQL enterprise Manager in the menu.

Green

Re: Historical reports sql database size UCCX 4.5

If you have SQL Server installed on another machine, you can add the Microsoft SQL Desktop Engine to the Server Group as another server, assuming they can see each other. That way you can see the database tables on the MSDE machine.

But the other poster is correct - the max size for MS SQL DE is 2GB.

Regards,

Geoff

499
Views
0
Helpful
4
Replies
CreatePlease to create content