Historical reports sql database size UCCX 4.5

Answered Question
Nov 18th, 2008

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

I have this problem too.
0 votes

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

Correct Answer by mikram about 8 years 2 weeks ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (2 ratings)
Loading.
htarra Wed, 11/26/2008 - 11:54

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

D_Lebedev Wed, 11/26/2008 - 21:46

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?

Correct Answer
mikram Thu, 11/27/2008 - 06:58

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.

Correct Answer

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

Actions

This Discussion