Migrate SQL Server to another site Considerations

TonyJK 876 Reputation points
2022-05-07T04:50:05.04+00:00

Hi,

We are going to migrating a SQL Server from SiteA to SiteB.

In SiteA, there is a SQL Server named SQL-A while there is one in SiteB called SQL-B.

There are 2 options
a) Migrate all databases in SQL-A Server to SQL-B Server
b) Migrate the whole database server SQL-A (Running on VMWare VM) to SiteB. We have sufficient number of SQL Server Licenses to cover them.

We would like to see what changes have to be made if we migrate all databases in SQL-A Server to SQL-B Server ? Currently, there are around 10 application databases reside on SQL-A Server. If we migrate to SQL-B Server, in addition to checking & updating connection strings, is there any other change that we need to take care ?

Thanks

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,300 questions
0 comments No comments
{count} votes

Accepted answer
  1. Erland Sommarskog 106.3K Reputation points
    2022-05-07T09:28:24.693+00:00

    One thing that comes to mind are server entities: Logins, Agent jobs, linked servers etc.

    But should probably also do some capacity planning to make sure that SQL-B can handle the load from the new databases. Maybe more RAM is needed. Maybe you need to extend tempdb etc.


1 additional answer

Sort by: Most helpful
  1. Mark Shelby 0 Reputation points
    2023-02-20T09:21:16.6266667+00:00

    Create the new server. Create the new server with the same disk configuration as the old one.

    Move the new system databases. Move the new system databases where you want them to reside in the future if you did not create them there during installation.

    Recreate logins.

    Create a script.

    0 comments No comments