[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 372
  • Last Modified:

Create new SQL server to replace old - Keep Machine Name

Hello:

I have a virtualized SQL server (we'll call SQL01).  It is on the domain.  I would like to move it to a physical box, but I need the physical box to keep the same name.  The databases are huge.  I'm looking for the best way to do this.

My concern is not knowing how SQL handles changes to the machine name.  Not sure which is better:

1) Rename the old server to "SQL01-old", then name the new server "SQL01".  Start the MSSQL install.

or

2) Install SQL on the new server, copy the database files over, then rename the servers

or

3) Something I haven't considered.

What do you think?

Thanks,

Dan
0
ddotson
Asked:
ddotson
  • 2
  • 2
1 Solution
 
Jason Yousef, MSSr. BI DeveloperCommented:
Hi,

which versions you're moving to and from?
which VM software you're using? there's tool to convert VM to Physical (V2P), just search for steps for your VM software version.
Just clone the VM as backup, then use the conversion tool to move over everything to the physical.

Let me know if you need more help.
0
 
Anthony PerkinsCommented:
If you do have the need to change the server name, make sure you configure SQL Server with the new name.
0
 
ddotsonAuthor Commented:
We are using SQL server 2008.  I'm not a big fan of conversions of I can avoid it.  I'm aware that the V2P tools exist, but I don't know much about them.

acperkins:  Do you mean that if I followed scenario 1, I'd need to configure the SQL servers?  What if the SQL server and its new machine name never really went into production?
0
 
Anthony PerkinsCommented:
Rather than give you disjointed pieces of information, let me just tell you to check out the MSDN article here:
How to: Rename a Computer that Hosts a Stand-Alone Instance of SQL Server
http://msdn.microsoft.com/en-us/library/ms143799(v=sql.105).aspx
0
 
ddotsonAuthor Commented:
Thanks for the help.  Sorry for the delay - haven't pulled the trigger yet.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now