InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 14:29:57 GMT20http://www.sqlservercentral.com/Forums/Topic908652-146-1.aspxYou can use the drop/add as Henrico pointed out. My question is - why would you want to do this? What benefit do you see that a fresh install of SQL won't give you?Thu, 22 Apr 2010 09:11:09 GMT tosscrosbyhttp://www.sqlservercentral.com/Forums/Topic908652-146-1.aspxYes, and no.run this to rename the server name:[code="sql"]sp_dropserver 'old_name' go sp_addserver 'new_name', 'local' go [/code]Thu, 22 Apr 2010 09:08:24 GMTHenrico Bekkerhttp://www.sqlservercentral.com/Forums/Topic908652-146-1.aspxIf i reastore the Master database of my instance 1 on my instance 2 what happens?Will the instance two be named as instance one?Thu, 22 Apr 2010 08:31:02 GMTriver1