Tuesday, June 25, 2013

Upgrade MDM 2012 to SP1(SQL Server 2012 to SP1)

Effects on MDM while updating SQL 2012 to sp1.
Must: take back up of MDM Database:
Right after update MDM site will come down….
1.       You need to go to MDM configuration manager select MDM database again.
2.       Once you do so it will ask you to update the database and SP1 make some database changes.
3.       While doing so it will wipe of your custom Stored Proc so This is where having backup is big help.