question

EvgenKotov-8588 avatar image
0 Votes"
EvgenKotov-8588 asked Cathyji-msft commented

Transferring an SCCM MS SQL server to another server

Hello,

The need for migrating MS SQL Enterpise servers intended for SCCM on MS SQL Standard
Please tell me how to perform steps to transfer the bases?

Is it possible to migrate the database on MS SQL Standard on another server, and then in DNS change the IP address MS SQL Enterprise on MS SQL Stnadard?
It turns out as follows in the SCCM, the SQL server name will remain old and when accessing it it will already refer to the new one.

sql-server-migration
· 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.

Hi @EvgenKotov-8588,

Any update for this thread? We have not received a response from you. Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·

Hi ,
Any update for this thread?

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @EvgenKotov-8588,

Did you want to create an alias for SQL server instance, then you can move the databases from server A to server B, but the application do not affect due to that change? if I misunderstood, please let me know.

You can using old alias name to create an alias for new instance, delete the old alias for old server, then the application can connect to the new instance using old connection string.

refer to this MS document Create or delete a server alias for use by a client.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
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.


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.