farisnt Posted April 10, 2013 Report post Posted April 10, 2013 Good Day I have Server1 that is hosting: SCCM 2012 SQL 2008 WSUS Reporting DP .... now I got my new SQL Server and looking for : How can I move the SQL database to the new location (Do I also need to move the reporting DB ) ? Is Moving the database named as (CM_"SiteID") will be enough and dose it include all the config like WSUS Database ...etc Incase the reporting service is not installed on the new SQL Server, will the SCCM reports work ??? Thanks alot Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted April 10, 2013 Report post Posted April 10, 2013 If I remember right there are instruction within the docs that will tell you how to move the db from server to another server. No it will not include the WSUS db. No the CM12 reports will not work until you fix the SSRS site, if you had SSRS before you can adjust the old SSRS site to use the the new database. Quote Share this post Link to post Share on other sites More sharing options...
farisnt Posted April 11, 2013 Report post Posted April 11, 2013 Thanks for your reply but will there be any problem if I move the CM12 DB and leave the WSUS DB on the local server, will all work OK ??? Quote Share this post Link to post Share on other sites More sharing options...
farisnt Posted April 12, 2013 Report post Posted April 12, 2013 Will it work if I only move the database it self without other database (master ...), moving CM_SiteCODE will it be enough ? Quote Share this post Link to post Share on other sites More sharing options...
GarthMJ Posted April 14, 2013 Report post Posted April 14, 2013 It should work fine, if you only move the CM db. Remember you will need to do a site reset. There are details instruction within the docs on how to move the db. Quote Share this post Link to post Share on other sites More sharing options...
