locked
Lync front end and backend csdatabase RRS feed

  • Question

  • I have changed backend sql installation path to d drive.

    But after I publish the topology , I found front end server on c:\csdatabase and back end c:\csdatabase.

    My client want to separate the DB to d drive.....

    One more things , I have one Lync platform with mirror database server have 90 GB  csdabase, Any advise to reduce the database? Perform backup sql and reduce the size?

    Thanks.

    Friday, April 14, 2017 2:34 PM

Answers

  • Hi Mick,

    As I am concerned, some location for sql db and sql log will be decided by system, as you said that, expect we manually re-locate it.

    Best Regards,
    Jim Xu
    TechNet Community Support


    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by JohnHK215 Tuesday, April 25, 2017 12:33 PM
    Tuesday, April 25, 2017 6:42 AM

All replies

  • Mick TT,

    SfB backend database cannot be moved because it hosts the CMS and you need the CMS to make topology changes. example: (Backend XDS database contains part of the Topology) If you want to under go this I would suggest creating a temporary pool to move the database (CMS) to the temporary pool and then back to the original pool at it's new location.

    Here is a blog about moving the backend database.

    https://blogs.technet.microsoft.com/nexthop/2010/12/20/change-a-pool-database-instance-when-the-pool-hosts-the-central-management-server/

    I am unsure about the mirrior database though. You might need to speak with some SQL people about that one.

    -Don

    Friday, April 14, 2017 6:07 PM
  • Thanks Don,

    I try to setup a lab and detach the database and move to d:\csdata.

    Remount it with d:\csdata

    Front end seems work fine, but after I update cu and perform 

    Install-CsDatabase -Update -ConfiguredDatabases -SqlServerFqdn <SQL Server FQDN>  -ExcludeCollocatedStores -databasepaths "d:\csdata", "d:\csdata"

    There have some database were update success but some failed.

    

    Saturday, April 15, 2017 3:47 AM
  • After few failure report, it work suddenly. no change on database.

    Anyone can advise how to pre-define csdata for front end ?

    Front end is depend on C and D drive? if we have D drive it will automatically to install on D drive?

    But unfortunately , my client have separate to front end C and D drive but the csdatabase still install on C drive.

    SQL Back end is follow the article as below?

    https://technet.microsoft.com/en-us/library/gg398832(v=ocs.15).aspx

    Thanks.


    • Edited by JohnHK215 Saturday, April 15, 2017 4:10 AM update
    Saturday, April 15, 2017 4:01 AM
  • Even enter select the data and log path, the log path still incorrect.

    D:\CsData\ABSStore\rtc\DbPath

    D:\CsData\ApplicationStore\rtc\DbPath

    best practice is use default path?

    Saturday, April 15, 2017 2:11 PM
  • Hi Mick,

    Did you mean you could not publish topology?
    From “Even enter select the data and log path, the log path still incorrect”, what is error that you get?

    To this issue, please make sure the correct database have been selected before this steps. Then enter the specific paths to the database files and the log files on the target server.  For database size, we suggest you do a backup for database to reduce database size.


    Best Regards,
    Jim Xu
    TechNet Community Support


    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, April 17, 2017 8:26 AM
  • Hi Jim,

    I can success publish the topology with data and log path.

    But the databases and logs have some to my type location but some databases and logs are on another location.

    Tuesday, April 18, 2017 1:01 PM
  • Hi Mick,

    Please read two notes in the snapshot. I also provide a snapshot for you:


    Best Regards,
    Jim Xu
    TechNet Community Support


    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Proposed as answer by jim-xu Friday, April 21, 2017 9:59 AM
    • Marked as answer by JohnHK215 Sunday, April 23, 2017 12:44 PM
    • Unmarked as answer by JohnHK215 Sunday, April 23, 2017 12:44 PM
    Friday, April 21, 2017 1:32 AM
  • So they is no method to do dedicate location for sql db and sql log ? expect we manually re-locate it on SQL server side?

    Thanks.

    Sunday, April 23, 2017 12:46 PM
  • Hi Mick,

    As I am concerned, some location for sql db and sql log will be decided by system, as you said that, expect we manually re-locate it.

    Best Regards,
    Jim Xu
    TechNet Community Support


    Please remember to mark the replies as answers if they helped.
    If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    • Marked as answer by JohnHK215 Tuesday, April 25, 2017 12:33 PM
    Tuesday, April 25, 2017 6:42 AM