Post reply

If i reastore the Master database of my instance 1 on my instance 2 what happens?

  • April 22, 2010 at 8:31 am

    #144245

    If i reastore the Master database of my instance 1 on my instance 2 what happens?

    Will the instance two be named as instance one?

  • April 22, 2010 at 9:08 am

    #1156193

    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

  • April 22, 2010 at 9:11 am

    #1156198

    You 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?

    -- You can't be late until you show up.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply