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
Last activity: Jun 21, 2016, 05:53 PM