Solved

Live Communication Server Database

Posted on 2008-06-17
8
827 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
  • 4
  • 3
8 Comments
 
LVL 29

Expert Comment

by:mass2612
Comment Utility
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
Comment Utility
The MSDE should be more than adequate for the number of users that you have.
0
 

Author Comment

by:Netsol-NOS
Comment Utility
Ok. Thanks for updating.
How can i view the users messages or chat.
0
 
LVL 12

Expert Comment

by:gaanthony
Comment Utility
You would need to setup an Archiving server to archiving IMs as no messages are kept in the rtc db.
0
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:Netsol-NOS
Comment Utility
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 500 total points
Comment Utility
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
Comment Utility
Thanks. It works fine.
0
 

Author Comment

by:Netsol-NOS
Comment Utility
Thanks for your support.

Query Works Fine.
0

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Join & Write a Comment

Consider a situation when you deploy a seemingly harmless software package to your network without testing and therefore without fully knowing the implications of your actions. I was recently involved in just this situation when a corporate IT netwo…
Case Summary: In this Article we introduce the new method to configure the default user profile using Automated profile copy with sysprep rather than the old ways such as the manual copy of a configured profile to default user profile Old meth…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now