Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Create a identical backup sql server for existing sql server Expand / Collapse
Author
Message
Posted Wednesday, August 21, 2013 6:55 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:55 AM
Points: 92, Visits: 220
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

Post #1486675
Posted Wednesday, August 21, 2013 7:04 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:46 PM
Points: 31,081, Visits: 15,527
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1486679
Posted Wednesday, August 21, 2013 7:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1486682
Posted Wednesday, August 21, 2013 7:13 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 8:55 AM
Points: 92, Visits: 220
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 ?
Post #1486686
Posted Wednesday, August 21, 2013 7:20 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 3:46 PM
Points: 31,081, Visits: 15,527
Restore. That's how you create an identical server. It's also how you practice DR.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1486694
Posted Wednesday, August 21, 2013 7:20 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
[quoteIs there a way to create a identical server ?[/quote]

if you say indentical then possible.


Regards
Durai Nagarajan
Post #1486695
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse