Category: OCS



Yesterday I have to repro cases from OCS, so the point is I have to move OCS DB to another server and I found this link : http://technet.microsoft.com/en-us/library/dd572422(v=office.13).aspx

I’ve already tried it on my lab and it works, but at my customer I failed so I have to rollback Sad smile.

Here’s the error when I want to Create Enterprise Pool

clip_image001

So after searching the internet and found KB from MS http://support.microsoft.com/kb/961944 and execute it but still the process won’t go.

With help from DBA and SQL Profiler to trace down what happen, it actually quite simple Smile. The Admin OCS lack of privilege in SQL Backend Server, so MS state when move the OCS DB it needs permission as member of RTCUniversalServerAdmins group, but the answer is it need sysadmin server role in the SQL Backend Server too!

Happy moving! Open-mouthed smile

Advertisements

So one of my customer had a request to move Archiving and Monitoring database in OCS 2007 R2 to another server. I build a lab for this, and here are the major steps:

  1. Stop services QoE Monitoring, Call Detail Recording, Archiving
  2. Detach database LcsCDR, QoeMetrics, LcsLog and copy necessary folders which have *.ldf and *.mdf files to destination server.
  3. Attach database to destination server.
  4. Activate service

Monitoring:

LCSCmd /Monitoring /Action:Activate /Password:*** /backend:SQLServerName\Instance

/qoedbdatapath:C:\QoEData /qoedblogpath:C:\QoELog /cdrdbdatapath:C:\CDRData

/cdrdblogpath:C:\CDRLog

Archiving:

LCSCmd.exe /Archiving /Action:Activate /Password:** /backend: SQLServerName\Instance  /dbname:LcsLog /DBDataPath:"C:\RTC Archiving Data" /DBLogPath:" C:\RTC Archiving Log"

Lastly you have to start the service back, that’s it, it’s a wrap! Smile

References: http://technet.microsoft.com/en-us/library/dd572313(office.13).aspx

Create a free website or blog at WordPress.com.
[ Back to top ]