Replicating the MDT Database

by Mitch Tulloch [Published on 18 May 2011 / Last Updated on 11 April 2010]

A tip concerning replicating the MDT database in a multi-site environment.

MDT 2010 supports the use of DFS for replicating deployment shares between sites. But what about replication the MDT database, which is typically either an SQL Server Express database or a full SQL Server database, between sites? Is this possible? And is it recommended?

Because the SQL query traffic for an MDT deployment is typically very small, replicating the SQL Server database between sites is not necessary. Instead, you should maintain a single instance of the MDT database at corporate headquarters and simply replicate the deployment share content out to your branch office sites.

If you want a more robust multi-site deployment platform however, consider using MDT 2010 together with System Center Configuration Manager 2007 R2 which provides additional capabilities not found in MDT alone.

If you have feedback concerning this tip, please email me. And be sure to check out my website!

See Also

The Author — Mitch Tulloch

Mitch Tulloch is a well-known expert on Windows Server administration and cloud computing technologies. He has published over a thousand articles on information technology topics and has written, contributed to or been series editor for over 50 books.

Featured Links