question

Chong-7118 avatar image
0 Votes"
Chong-7118 asked TomDee-4442 published

Migrate SCCM CB2010 and SQL 2012 to new 2019 servers

Hi all,

We have two Win2012 servers which installed SCCM CB2010 and SQL 2012 Server. Now we planning to migrate them to Win2019 server and SQL 2019 Server
Seems we can use backup and recovery to migrate the SCCM to new server.

For the SQL server, do we need to migrate the existing SQL server first? Or just backup the database and restore to new SQL 2019 Server? How about the reporting services

Thanks

Chong

mem-cm-generalsql-server-reporting-servicessql-server-migration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

FionaYan-MSFT avatar image
0 Votes"
FionaYan-MSFT answered TomDee-4442 published

@Chong-7118

Thank you for posting in Microsoft Q&A forum.

There are many methods to perform the action, it's recommended that using in-place SQL upgrades and Site backup and restore.

The mainly steps should be like this:

  • In-place upgrade to SQL 2019 on the old server.

  • Migrate SQL to new server (2019).

  • Backup/restore SCCM primary site to the new OS server (same name for the server).

  • Move the database and SCCM roles.

  • SQL and SCCM same box (Server 2019 and SQL 2019).

The following articles including the site backup and restore:
backup-and-recovery the site
recover the sites

Also, we could refer to these two excellent blogs:
https://home.memftw.com/configmgr-site-backup-restore/
https://www.sysinfotools.com/blog/migrate-sql-server-database-from-one-server-to-another/
Note: This is non-official Microsoft article just for your reference.

Have a nice day!


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Chong-7118 avatar image
0 Votes"
Chong-7118 answered Jason-MSFT commented

Hi @FionaYan-MSFT,

Thanks for the information.

For the "Backup/restore SCCM primary site to the new OS server (same name for the server)", it should use the same server name?
So we need to cleanup the existing SCCM server and disjoint it from the domain, then setup a new SCCM server?

This should required very long downtime. Any method can have shorter download time for the server migration?

Thanks

Chong

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Chong-7118

Thank you for the quickly reply.

The Backup/restore is the easier way I would recommend otherwise you will have a lot of work to do. The backup/restore method need to use same name for the server. We could shutdown the existing SCCM server instead of cleaning and disjoin from the domain.

Have a good day!

0 Votes 0 ·

So we need to cleanup the existing SCCM server and disjoint it from the domain

No. My recommendation is shut down and disable the SQL and ConfigMgr services and simply rename the server. That way, it's still available on the network for anything you forget and also easy to fallback to if necessary.

0 Votes 0 ·
Chong-7118 avatar image
0 Votes"
Chong-7118 answered FionaYan-MSFT commented

Sorry that I am new on SCCM so may have many thing unclear

As we have existing SQL 2019 server for other services already, if we want to recovery the SCCM to this SQL, the step will be:

  1. In-place upgrade to SQL 2019 on the old SCCM SQL 2012 server.

  2. Migrate the SCCM DB to new SQL 2019 server.

  3. Backup/restore SCCM primary site to the new OS server (same name for the server).

  4. Move the database and SCCM roles. <<< Can explain more about this? The SQL and SCCM still to configure after restore to new server?


Thanks


Chong

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Chong-7118

Thank you for the kindly reply.

The step 4 means we need to check if we have moved the database and SCCM roles successfully. The logical steps like this:

  • In-place upgrade to SQL 2019 on the old SQL 2012 server.

  • Migrate SQL DB to new server (2019).

  • Backup/restore SCCM primary site to the new OS server (same name for the server).

  • SQL and SCCM same box (Server 2019 and SQL 2019).

Thanks a lot.

0 Votes 0 ·

@Chong-7118

May we know the current status of the question? If there is any other assistance we can provide, please feel free to let us know, we will do our best to help you.

0 Votes 0 ·
Chong-7118 avatar image
0 Votes"
Chong-7118 answered FionaYan-MSFT commented

Hi @FionaYan-MSFT

I tried to restore the SCCM to the new server (Just restore the site server, SQL not restore as we will use the existing SQL first). The setup is completed but some components still "installing"
56350-2.jpg


And the SCCM site cannot be connected
56388-3.jpg



Any idea?

Thanks

Chong


2.jpg (42.1 KiB)
3.jpg (54.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Chong-7118

Thank you for the update.

  • For troubleshooting the process of the installation, please check the ConfigMgrSetup.log located on C drive.

  • We could also click view log to see what happened during the process.

  • May we know if we could click the next button? Have we wait some time after installation and then open the CM console?(Because some components are still installing)

  • For "the SCCM site cannot be connected", please check the SmsAdminUI.log(C:\Program Files (x86)\Microsoft Configuration Manager\AdminConsole\AdminUILog) Does the user have the correct permissions to connect to the site server?



0 Votes 0 ·
Chong-7118 avatar image
0 Votes"
Chong-7118 answered Chong-7118 commented

Hi @FionaYan-MSFT

I see the elapsed time stopped and wait around 1 hours but those components still show "installing" so I click next to completed the wizard.

From the SmsAdminUI.log, it have some RPC server error. I tried to fixed the problem as below:

https://social.technet.microsoft.com/Forums/en-US/6c55a1c8-64c7-4720-bc8d-a4ee25856b1e/sccm-console-cannot-connect-to-database?forum=ConfigMgrDeployment
http://schadda.blogspot.com/2012/08/how-to-fix-issues-related-with_7.html

But it still have many "ProviderLoadFailure" error and don't have more information to me
56467-smsadminui.log

Thanks

Chong



smsadminui.log (115.9 KiB)
· 8
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Chong-7118

The core setup is completed does not really means this process was finished. We need to wait for more than one hour. We could open the ConfigMgrSetup.log to see the details of the installation process, we may see in the log with "exit" also with many "=", so we may need to be patient.

Thanks a lot.

0 Votes 0 ·

@FionaYan-MSFT

I setup another server to restore the SCCM. Same as last time, the SCCM console in new server cannot be access with same error
During the setup, the Elapsed time increase and the Next button is dim before the setup complete. When the setup "complete", it let me click Next and the installation log show completed, but some components still show installing...

57425-4.jpg


0 Votes 0 ·
4.jpg (189.1 KiB)

@Chong-7118

It seems that the WMI provider attempts to access to the site database and after several times it failed. Have we checked the Smsprov.log on our server side already?

Have a nice day!

0 Votes 0 ·
Show more comments
Chong-7118 avatar image
0 Votes"
Chong-7118 answered FionaYan-MSFT commented

@FionaYan-MSFT

The console still cannot access today, and the log didn't increase anymore. So the installation is not complete and I need to setup another server to perform restore again?

Thanks

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@Chong-7118

As we know, each production environment varies. For the problem we are facing, based on my personal experience, remote assistance may be needed. Unfortunately, this is not available in the community currently due to limited resource. We recommend you to open a phone ticket with MS so that a dedicated support engineer may help on this. Meanwhile, I will try the best to repo the issue in my lab to see if we can provide some clue to help on this and keep you updated. Thank you for your kind understanding and have a nice weekend!


0 Votes 0 ·