Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Rename Server Expand / Collapse
Author
Message
Posted Thursday, May 1, 2014 12:12 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 101, Visits: 942
I have server name called X and i want to convert this server using Virtual to virtual.However, I want to rename this server to Y.What are the steps to rename the server after V2V conversion?
Post #1566819
Posted Thursday, May 1, 2014 12:36 PM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 8:31 AM
Points: 3,180, Visits: 3,495
You need to run sp_dropserver and sp_addserver after renaming the machine. Also, if you have SQL Agent jobs that reference the server name, you will need to update those as well.

http://technet.microsoft.com/en-us/library/ms143799.aspx
Post #1566822
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse