SQL Express Replicated Database on a Site System (non-Secondary Site) Server with Management Point RRS feed

  • Question

  • Is it possible and/or supported for a site system with the Management Point role to use a pre-configured instance of SQL Express with a replicated database from the Primary Site DB?  I only see mention of using SQLExpress on Secondary sites that have the Management Point role.

    Is it assumed that additional Management Points on site systems within a Primary Site SHOULD contact the site database itself and be connected on a fast link (this is what the online documentation seems to hint at) - even though the option to use a replicated SQL database is there?

    My Personal Blog: http://madluka.wordpress.com

    Thursday, March 7, 2013 10:59 AM

All replies

  • No. For MP replicas (which is what many call this feature), a full version of SQL Server is required; this is discussed at http://technet.microsoft.com/en-us/library/hh846234.aspx

    Jason | http://blog.configmgrftw.com

    Thursday, March 7, 2013 2:22 PM
  • One comment, SQL standard is included in the license and can be installed on the MP as part of the existing license agreement.

    Kent Agerlund | My blogs: blog.coretech.dk/kea and SCUG.dk/ | Twitter: @Agerlund | Linkedin: Kent Agerlund | Mastering ConfigMgr 2012 The Fundamentals

    Thursday, March 7, 2013 2:24 PM
  • Should it be possible to perform Operating System Deployments where the only MP available to the client is using a replica Database - because my test client fails to retrieve any policies.  If I set the MP back to accessing the site database then all is well.  I have taken the MP role off my primary site server and have this on a site system instead - so in this environment there is NO management point which accesses the full site database.

    The mpcontrol.log and mpsetup.log on the MP using a replica DB seems happy with using the replica database/server, which I used the documentation guide to set up and configure - it seems to be replicating but the replica Database is tiny in comparision - < 100MB, is that normal?  This is only a Virtual lab environment.  The Replication monitor within SQL Management Studio running against the site database publishing server shows a healthy Job History "success starting agent" but the navigation pane in there shows an exclamation mark against the "ConfigMgr_MPReplica" subscription - but within there I have Status=OK and Snapshot Agent Job shows Completed but with Last Action "[0%] A snapshot was not generated because no subscriptions needed initialization" - I assume initialization is a one time thing?  When I first set up replication, the replication monitor did show a lot of tables etc. being replicated.

    There doesn't seem to be much guidance on what 'functions' using a replica database is good for.  Is it just that OSD has too many cogs and the MP used requires access to the full site database to provision new systems?

    Has anyone tried OSD from an MP which is accessing a replica database?  Just how much redundancy do/should we get with a replica DB - full/partial? Are replica databases only to be used on an MP where there are other MP's available which access the site database?

    My Personal Blog: http://madluka.wordpress.com

    Sunday, March 10, 2013 4:02 PM
  • I had to do this on my Replica Database server, which is something not listed in the documentation set for creating the Replicated MP Database;


    Without this, the client would not obtain policy.  So far so good though, I have Operating System Deployment working with the client accessing an MP with a replicated database, without any management point on the primary site server.  I have even 'paused' the Primary Site Server virtual machine to understand what effect, if any, this will have on the client during OSD - I suspect site assignment/server location may be an issue.

    If anyone knows of a document anywhere which details the functionality possible during the loss of site components/servers for SCCM 2012 I would very much like to see that.

    My Personal Blog: http://madluka.wordpress.com

    Tuesday, March 12, 2013 12:21 PM