Migrate SQL Server to another site Considerations

Question

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

Answer 1

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.

Answer 2

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.