Server Renaming after Upgrade

Question

Hello,
We are going to upgrade and migrate the Sql server from 2008 to 2014 to new server but we need to rename the server to old server due lots of reports and jobs needs to be changed to reflect the new server name we decided to keep the old server name.

Ex.
Sql2008 - Old Server
Sql2014 - New server

after migrating databases from Sql2008 to Sql2014, we will rename the Sql2014 to back to Sql2008 so we don't have to change data source for any job or reports.
This is a Production migration so i am thinking to create another dummy server and use that server to rename for testing purpose and how it works, is ti possible?
Existing Old server running is Sql2008
New Server is Sql2014
3rd Dummy server will be SqlDummy
So once I migrate from Sql2008 to Sql2014, I will rename it to SqlDummy instead of Sql2008, This is just drill exercise to avoid any SPN issue.
I have already installed Sql server on Sql2014 but question is that do i need to install Sql server on SqlDummy as I will be using only for renaming?

Thanks

Answer 1

Thanks PAtrick.
Sorry, I mean Turning off Production Server will cause issue (sorry not DNS) as we are running lots of jobs and reports.
So coming back to my original question, what's your thoughts?
"Do you think if I create the Dummy server to use for Renaming and using IP Address for testing will work without Sql server installation as I have already Sql server installed on SQl2014 as i am just renaming this server to DummySql?"

Answer 2

Thanks Patrick.
You meant to say without installing Sql server will work when we use the DummyServer name - DummySql?

Answer 3

Hi @Pds ,

If you migrated your SQL server and you do not want make a change for the applications that connect to the old SQL server. Suggest you using SQL server Alias to resolve this issue. By using an alias, we can keep the application configuration the same.

Refer the blog Overview of SQL Server Aliases to get the detail steps about creating SQL server alias.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 4

Hi @Pds ,

> I am asking in terms of when we have Transaction Log backup running/Enabled and if we take the FULL backup instead of COPY_ONLY Full backup will break the Log chain sequence?

No, full back up will not break the Log chain sequence. But log backup will break the Log chain sequence. So if you want do a log backup ,suggest you using copy only option.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.

Answer 5

Hi @Pds ,

> During backing up when DMA running FULL Backup to share folder not sure which cause to break the log chain as we are running hourly Transaction log backup (every hour) so i am just curios should I stop the Transaction Log backup job during that time or let DMA run the backup and restore and that will safe process which will not affect any log chain sequence.

The DMA also has log back up. It does a data backup and log backup. It has the data files and log files as below screenshot. Suggest you stopping the transaction log backup job during that time.

---

If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.