Create a identical backup sql server for existing sql server

  • Is there a way to create a identical backup sql server for existing sql server 2005.

    We would like to keep the same name also.

    The new server will have exact configuration as current.

    - All the Email setting

    - All the Jobs

    - All special settings

  • You can't have the same name on the network because of Windows restrictions.

    If you want to set up a DR type server you can bring online, then you should restore all backups, including master, and have it on a separate (or off the) network. Then before bringing it online, restore the latest backups.

  • skb 44459 (8/21/2013)


    Is there a way to create a identical backup sql server for existing sql server 2005.

    We would like to keep the same name also.

    The new server will have exact configuration as current.

    - All the Email setting

    - All the Jobs

    - All special settings

    Why do you want to do so?

    you cant do as steve said it is windows restriction but you can set a Disater recovery server using mirroring , Log shipping, Replication for that you need exactly the similar server like same drive configuration etc.

    Application also supports DR's..

    Regards
    Durai Nagarajan

  • We are not going to put it on the same network.

    This will be our DR server, just in case.

    Is there a way to create a identical server ?

  • Restore. That's how you create an identical server. It's also how you practice DR.

  • [quote-0Is there a way to create a identical server ?[/quote-0]

    if you say indentical then possible.

    Regards
    Durai Nagarajan

Viewing 6 posts - 1 through 5 (of 5 total)

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