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.

mass2612

Hi,

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-DB-Backup

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

gaanthony

The MSDE should be more than adequate for the number of users that you have.

Netsol-NOS

ASKER

Ok. Thanks for updating.
How can i view the users messages or chat.

gaanthony

You would need to setup an Archiving server to archiving IMs as no messages are kept in the rtc db.

Netsol-NOS

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

gaanthony

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds. No credit card required.

See answer

Netsol-NOS

ASKER

Thanks. It works fine.

Netsol-NOS

ASKER

Thanks for your support.

Query Works Fine.