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 Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, November 14, 2014 4:18 PM
Points: 98, Visits: 890
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
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 21, 2014 2:49 PM
Points: 2,927, Visits: 3,151
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