?
Solved

Live Communication Server Database

Posted on 2008-06-17
8
Medium Priority
?
876 Views
Last Modified: 2013-11-29
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.
0
Comment
Question by:Netsol-NOS
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
8 Comments
 
LVL 29

Expert Comment

by:mass2612
ID: 21802336
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
0
 
LVL 12

Expert Comment

by:gaanthony
ID: 21809611
The MSDE should be more than adequate for the number of users that you have.
0
 

Author Comment

by:Netsol-NOS
ID: 21809830
Ok. Thanks for updating.
How can i view the users messages or chat.
0
10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

 
LVL 12

Expert Comment

by:gaanthony
ID: 21817240
You would need to setup an Archiving server to archiving IMs as no messages are kept in the rtc db.
0
 

Author Comment

by:Netsol-NOS
ID: 21844105
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.
0
 
LVL 12

Accepted Solution

by:
gaanthony earned 2000 total points
ID: 21861599
User SQL Query Analyzer or the SQL Server Managemet console and open the lcslog database and run the following query replacing userid@<domain.com' with the sip URI of the user you are looking to see the archived IMs from.

Select * from lcslog.dbo.messages, lcslog.dbo.users where lcslog.dbo.users.userid
= fromid and lcslog.dbo.users.useruri = 'userid@<domain.com'
0
 

Author Closing Comment

by:Netsol-NOS
ID: 31467885
Thanks. It works fine.
0
 

Author Comment

by:Netsol-NOS
ID: 21874056
Thanks for your support.

Query Works Fine.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Some time ago I faced the need to use a uniform folder structure that spanned across numerous sites of an enterprise to be used as a common repository for the Software packages of the Configuration Manager 2007 infrastructure. Because the procedu…
Have you considered what group policies are backwards and forwards compatible? Windows Active Directory servers and clients use group policy templates to deploy sets of policies within your domain. But, there is a catch to deploying policies. The…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question