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 |
|
roadkillchicken
Starting Member
3 Posts |
 Posted - 2014-07-25 : 13:55:43
|
| Hi all,I have a quick question, hopefully someone can point me in the right direction.We have two SQL 2012 servers, sever A and B.We need to sync a database on A so that there is a copy of it on B (ideally keeping the sync as real time as possible).We need to be able to query both databases so mirroring isn't an option.Can anyone suggest a way of doing this?Thanks in advance,L |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-25 : 14:00:13
|
| You can use Availability Groups for this with a readable secondary. What edition are you using?Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
roadkillchicken
Starting Member
3 Posts |
Posted - 2014-07-25 : 14:06:07
|
| HiSQL 2012, Standard 64bit |
|
|
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2014-07-25 : 14:13:54
|
| I think you need Enterprise to use always on. If you can't do Mirroring with database snapshots, you could set up transactional replication or log shipping with very high frequency (like per minute or two). Transactional replication would probably be better. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-25 : 14:18:40
|
| I would recommend transactional replication since log shipping will disconnect the users each time it needs to do a restore.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
roadkillchicken
Starting Member
3 Posts |
Posted - 2014-07-25 : 14:20:10
|
| Thanks all - I'll take a look at transactional replication. Does anyone have a good (and easy) step by step guide? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-07-25 : 14:25:05
|
| I don't have a guide, but the wizard does a good job of walking you through it. But when it errors (either the replication setup or later when it's running) is when the fun starts. Google and this forum will be your friend.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Automatically syncing database to different server