Sample Header Ad - 728x90

Migrate Management Data Warehouse to a New Instance

3 votes
1 answer
744 views
Is there a defined procedure to follow for moving a SQL Server 2012 Management Data Warehouse to a new server\instance? We intend to setup MDW on a test SQL Server instance first, but will then want to migrate it to a production installation. I can't find any information on this. Two points which are concerns are: 1. To migrate the databases without losing data. 2. How to update the registered instances to report their data to the new MDW instance.
Asked by user41566
Jun 24, 2014, 02:28 PM
Last activity: Jun 21, 2016, 05:53 PM