Home Forums SQL Server 2005 Administering If i reastore the Master database of my instance 1 on my instance 2 what happens? RE: If i reastore the Master database of my instance 1 on my instance 2 what happens?

  • Yes, and no.

    run this to rename the server name:

    sp_dropserver 'old_name'

    go

    sp_addserver 'new_name', 'local'

    go

    -----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle