Solved

Create new SQL server to replace old - Keep Machine Name

Posted on 2012-04-11
5
351 Views
Last Modified: 2012-04-26
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
Comment
Question by:ddotson
  • 2
  • 2
5 Comments
 
LVL 21

Expert Comment

by:Jason Yousef, MS
ID: 37835558
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
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 37835594
If you do have the need to change the server name, make sure you configure SQL Server with the new name.
0
 

Author Comment

by:ddotson
ID: 37835868
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
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 37835916
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
 

Author Closing Comment

by:ddotson
ID: 37900144
Thanks for the help.  Sorry for the delay - haven't pulled the trigger yet.
0

Featured Post

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Access sql to sql server express 10 31
Live Storage Vmotion VMs with shared VMDK 10 51
How to search for strings inside db views 4 24
Tsql query 6 18
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
I have a large data set and a SSIS package. How can I load this file in multi threading?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

816 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now