How to Add/Remove the Server (Computer)?

How to Add/Remove the Server (Computer)?

There are some situations at which you need to Add/Remove the Server (Computer) to your SQL Server instance.

Here is a scenario. Your database server name is changed from Old_Server to New_Server. Even after changing your database server name, your SQL Server Instance will be pointing to the Old_Server name. This may affect the SQL Agent jobs.You may be facing problems in Add/Edit the scheduled jobs some times.

To avoid this you need to remove the Old_Server and add the New_Server name.

To know the current Server name run the below command:

SP_HELPSERVER

To remove the Old_Server run the below command:

SP_DROPSERVER ‘Old_Server’

To add the New_Server run the below command:

SP_ADDSERVER ‘New_Server’

After completing this process you will see that your SQL Agent Jobs will be start working fine.

For more information see the Microsoft links:

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: