August 21, 2013 at 6:55 am
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
August 21, 2013 at 7:04 am
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.
August 21, 2013 at 7:10 am
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
August 21, 2013 at 7:13 am
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 ?
August 21, 2013 at 7:20 am
Restore. That's how you create an identical server. It's also how you practice DR.
August 21, 2013 at 7:20 am
[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