Netsol-NOS
asked on
Live Communication Server Database
I am using LCS 2005 Standard Edition in my Network (500 Users). I have installed LCS 2005 with default database i.e. MSDE. Now i want to know that at which extent i can grow the MSDE database and how i can view the MSDE database.
What you suggest for future related to MSDE database mean it support large size.
What you suggest for future related to MSDE database mean it support large size.
The MSDE should be more than adequate for the number of users that you have.
ASKER
Ok. Thanks for updating.
How can i view the users messages or chat.
How can i view the users messages or chat.
You would need to setup an Archiving server to archiving IMs as no messages are kept in the rtc db.
ASKER
I have activated and configured Archiving Service on same LCS Server with SQL Server 2000 backend Database. And MSMQ service also enabled on same Server. Now how can i verify that My Archiving Service works fine. And How can i view users chat from Database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks. It works fine.
ASKER
Thanks for your support.
Query Works Fine.
Query Works Fine.
MSDE has a 2GB maximum size for the database and SQL Express 2005 has a maximum size of 4GB.
MSDE does not have a GUI so you need to use osql.exe. But LCS includes a tool to backup the database: -
Dbbackup /backupfile:c:\backup\LCS-
How to manage the SQL Server Desktop Engine (MSDE 2000) or SQL Server 2005 Express Edition by using the osql utility
http://support.microsoft.com/kb/325003
Upgrading MSDE 2000 to SQL Server 2005 Express
http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx