Solved

Live Communication Server Database

Posted on 2008-06-17
8
839 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
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
 
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
The curse of the end user strikes again      

You’ve updated all your end user’s email signatures. Hooray! But guess what? They’re playing around with the HTML, adding stupid taglines and ruining the imagery. Find out how you can save your signatures from end users today.

 

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 500 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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

My previous article  (http://www.experts-exchange.com/OS/Microsoft_Operating_Systems/Server/Windows_Server_2008/A_4466-A-beginners-guide-to-installing-SCCM2007-on-Windows-2008-R2-Server.html)detailed one possible method to get SCCM 2007 installed an…
Welcome to my series of short tips on migrations. Whilst based on Microsoft migrations the same principles can be applied to any type of migration. My first tip Migration Tip #1 – Source Server Health can be found here: http://www.experts-exchang…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 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

11 Experts available now in Live!

Get 1:1 Help Now