Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2012-05-14 : 06:58:37
|
| What is the best way to make a mirror of an sql database that won't slow down performance?is it best to use sql server 2008 replication or is their a benefit to the redgate software?Please advise their is always data being added and the structure of the tables also change (a few times a week) |
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-05-14 : 12:21:58
|
| What is the purpose of the mirrored database?HA, reporting etc?----------------------------Junior DBA learning the ropes |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2012-05-14 : 12:39:53
|
| we want it to be a copy of the database so in case of server failing we have a copy we can revert to |
|
|
|
chris_cs
Posting Yak Master
223 Posts |
Posted - 2012-05-15 : 04:36:41
|
| Then you should look into mirroring or log shipping. It depends on whether you'd like automatic failover or not, in which case mirroring would be your best bet.In terms of performance you may have to read up on the different modes you can use with mirroring. If you want to have automatic failover there is a chance you could see a performance hit in your application if the connection between the servers is poor.----------------------------Junior DBA learning the ropes |
|
|
|
|
|
|
best way to mirror a sql server