We have fresh deployment of SCSM 2012 R2 UR5.

There were lot of issues with existing SCSM 2012 Sp1 so we wanted to start fresh.

Is there a way we can import all the reporting data from past SCSM to new Datawarehouse so that we DON'T loose all past reporting data with our this decision.

Is there a documented process which can reuse existing DW database or restore of DW database for such purposes ? or any way to achieve the same ? can backup restore process of DW help in this

Hi,

you can reinstall the new DW server using the existing DW database. For the purpose you first have to back up the encryption key, so that you can use it during the restoration procedure. As a reference you can use the SCSM Disaster Recovery Guide from MS:

Disaster Recovery Guide for System Center 2012 - Service Manager
https://technet.microsoft.com/en-us/library/hh495602.aspx

and

How to Recover a Data Warehouse Management Server
https://technet.microsoft.com/en-us/library/hh524223.aspx

Hope this helps.

Regards,

Stoyan

• Edited by Stoyan Chalakov 19 hours 3 minutes ago

 No.

 The same guide says: Only one recovery scenario is possible for the data warehouse management server: you must install a new data warehouse management server on a computer with the same computer name as the computer that failed.

 

 Our case, we've setup the whole infra using new computer names so that old setup remains intact while we prepare a new setup in parallel.

Yes, in this case the steps from the disaster recovery guide are not applicable.
If this is possible, it should be done on the SQL level, but I am not aware of anybody, who has done it.

Any chance you have read this:

from:
Moving the Service Manager and DW Databases
http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx

"If you have recently installed SCSM it might be easier to just unregister the data warehouse, install a new datawarehouse, and register it again.  As long as the data hasn't been groomed from the SCSM database yet, there will be no data loss in the DW database because it will all be sync'd back over again.  By default the grooming interval for work items is 90 days from the last time a work item was modified.  So - if you installed SCSM anytime within the last 90 days and you haven't changed the grooming interval you can just unregister the DW, install a new DW, and register it with SCSM.  That's much easier than the DW DB move documentation we are going to put out."

Regards,

Stoyan

• Marked as answer by Shahid Roofi 10 hours 29 minutes ago

Hi,

you can reinstall the new DW server using the existing DW database. For the purpose you first have to back up the encryption key, so that you can use it during the restoration procedure. As a reference you can use the SCSM Disaster Recovery Guide from MS:

Disaster Recovery Guide for System Center 2012 - Service Manager
https://technet.microsoft.com/en-us/library/hh495602.aspx

and

How to Recover a Data Warehouse Management Server
https://technet.microsoft.com/en-us/library/hh524223.aspx

Hope this helps.

Regards,

Stoyan

• Edited by Stoyan Chalakov Tuesday, April 28, 2015 12:10 PM

Hi,

you can reinstall the new DW server using the existing DW database. For the purpose you first have to back up the encryption key, so that you can use it during the restoration procedure. As a reference you can use the SCSM Disaster Recovery Guide from MS:

Disaster Recovery Guide for System Center 2012 - Service Manager
https://technet.microsoft.com/en-us/library/hh495602.aspx

and

How to Recover a Data Warehouse Management Server
https://technet.microsoft.com/en-us/library/hh524223.aspx

Hope this helps.

Regards,

Stoyan

• Edited by Stoyan Chalakov Tuesday, April 28, 2015 12:10 PM

Hi,

you can reinstall the new DW server using the existing DW database. For the purpose you first have to back up the encryption key, so that you can use it during the restoration procedure. As a reference you can use the SCSM Disaster Recovery Guide from MS:

Disaster Recovery Guide for System Center 2012 - Service Manager
https://technet.microsoft.com/en-us/library/hh495602.aspx

and

How to Recover a Data Warehouse Management Server
https://technet.microsoft.com/en-us/library/hh524223.aspx

Hope this helps.

Regards,

Stoyan

• Edited by Stoyan Chalakov Tuesday, April 28, 2015 12:10 PM

Hi,

you can reinstall the new DW server using the existing DW database. For the purpose you first have to back up the encryption key, so that you can use it during the restoration procedure. As a reference you can use the SCSM Disaster Recovery Guide from MS:

Disaster Recovery Guide for System Center 2012 - Service Manager
https://technet.microsoft.com/en-us/library/hh495602.aspx

and

How to Recover a Data Warehouse Management Server
https://technet.microsoft.com/en-us/library/hh524223.aspx

Hope this helps.

Regards,

Stoyan

• Edited by Stoyan Chalakov Tuesday, April 28, 2015 12:10 PM

Yes, in this case the steps from the disaster recovery guide are not applicable.
If this is possible, it should be done on the SQL level, but I am not aware of anybody, who has done it.

Any chance you have read this:

from:
Moving the Service Manager and DW Databases
http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx

"If you have recently installed SCSM it might be easier to just unregister the data warehouse, install a new datawarehouse, and register it again.  As long as the data hasn't been groomed from the SCSM database yet, there will be no data loss in the DW database because it will all be sync'd back over again.  By default the grooming interval for work items is 90 days from the last time a work item was modified.  So - if you installed SCSM anytime within the last 90 days and you haven't changed the grooming interval you can just unregister the DW, install a new DW, and register it with SCSM.  That's much easier than the DW DB move documentation we are going to put out."

Regards,

Stoyan

• Marked as answer by Shahid Roofi Tuesday, April 28, 2015 8:45 PM

Yes, in this case the steps from the disaster recovery guide are not applicable.
If this is possible, it should be done on the SQL level, but I am not aware of anybody, who has done it.

Any chance you have read this:

from:
Moving the Service Manager and DW Databases
http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx

"If you have recently installed SCSM it might be easier to just unregister the data warehouse, install a new datawarehouse, and register it again.  As long as the data hasn't been groomed from the SCSM database yet, there will be no data loss in the DW database because it will all be sync'd back over again.  By default the grooming interval for work items is 90 days from the last time a work item was modified.  So - if you installed SCSM anytime within the last 90 days and you haven't changed the grooming interval you can just unregister the DW, install a new DW, and register it with SCSM.  That's much easier than the DW DB move documentation we are going to put out."

Regards,

Stoyan

• Marked as answer by Shahid Roofi Tuesday, April 28, 2015 8:45 PM

Yes, in this case the steps from the disaster recovery guide are not applicable.
If this is possible, it should be done on the SQL level, but I am not aware of anybody, who has done it.

Any chance you have read this:

from:
Moving the Service Manager and DW Databases
http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx

"If you have recently installed SCSM it might be easier to just unregister the data warehouse, install a new datawarehouse, and register it again.  As long as the data hasn't been groomed from the SCSM database yet, there will be no data loss in the DW database because it will all be sync'd back over again.  By default the grooming interval for work items is 90 days from the last time a work item was modified.  So - if you installed SCSM anytime within the last 90 days and you haven't changed the grooming interval you can just unregister the DW, install a new DW, and register it with SCSM.  That's much easier than the DW DB move documentation we are going to put out."

Regards,

Stoyan

• Marked as answer by Shahid Roofi Tuesday, April 28, 2015 8:45 PM

Yes, in this case the steps from the disaster recovery guide are not applicable.
If this is possible, it should be done on the SQL level, but I am not aware of anybody, who has done it.

Any chance you have read this:

from:
Moving the Service Manager and DW Databases
http://blogs.technet.com/b/servicemanager/archive/2012/04/22/moving-the-service-manager-and-dw-databases.aspx

"If you have recently installed SCSM it might be easier to just unregister the data warehouse, install a new datawarehouse, and register it again.  As long as the data hasn't been groomed from the SCSM database yet, there will be no data loss in the DW database because it will all be sync'd back over again.  By default the grooming interval for work items is 90 days from the last time a work item was modified.  So - if you installed SCSM anytime within the last 90 days and you haven't changed the grooming interval you can just unregister the DW, install a new DW, and register it with SCSM.  That's much easier than the DW DB move documentation we are going to put out."

Regards,

Stoyan

• Marked as answer by Shahid Roofi Tuesday, April 28, 2015 8:45 PM

  Let's hope the steps are still applicable on 2012 R2 UR5 - giving it a try