Changing SQL Server name

[mutley1]

Hi all,

We have a few machines where the @@servername and machine name don't match, so I'm going to do an sp_dropserver and then sp_addserver 'machinename', 'local' to get them up to speed.

There are no remote servers, only local logins so that should be fine, and the msdb.sysjobs has the machinename as the originating_server (which is what I am going to set the @@servername to).

I'm having a blank in my head - Is this OK to do during the day & is a reboot required? I will obviously back up the master beforehand.

Cheers,

M.

 

[ptheriault]

You won't need to reboot but you will need to restart the SQL services.

- Paul
- Database performance looks fine, it must be the Network!

 

[mutley1]

Thanks Paul!