Historical reports sql database size UCCX 4.5

Answered Question
Nov 18th, 2008
User Badges:

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

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 7 months 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
User Badges:
  • Bronze, 100 points or more

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
User Badges:

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
User Badges:
  • Bronze, 100 points or more

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