August 22, 2011 at 10:08 am
I always think a warm standby database is for disaster recovery only and it is mostly used for read only.
Can I insert, delete and update data in the warm stand by database and how can I sync up with the primary database when it is up and running?
Thanks
August 22, 2011 at 10:09 am
Depends on what technology you're using to create that warm standby. Mirroring or log shipping?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2011 at 10:32 am
I am using replication.
August 22, 2011 at 10:35 am
Then your failback is entirely manual and you must figure out how to get the data back. Replication is not strictly a HA/DR technology.
You could use something like RedGate's SQLDataCompare, you could backup the subscriber, restore to the publisher and then reset the replication up or you could do a manual sync.
p.s. if you insert and delete data in the subscriber while the publisher is still running you're risking broken replication (conflicts)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 22, 2011 at 10:44 am
If I use data mirroring, would it be better?
August 22, 2011 at 2:04 pm
Loner (8/22/2011)
If I use data mirroring, would it be better?
no, you cannot update the mirror unless you failover to it, but then its no longer a warm standby!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 23, 2011 at 10:28 pm
Replication is used to replicate the data to diff location or instance and standby solution is for failover if Primay is not available. Generally standby ( using mirroring or Log shipping ) will be in read only mode.
Using Replication you can sync data at both the end, depends what type of replication you are using. If it is a merge or transactional replication.
"More Green More Oxygen !! Plant a tree today"
August 24, 2011 at 12:51 am
Minaz Amin (8/23/2011)
Generally standby ( using mirroring or Log shipping ) will be in read only mode.
A mirror database will only be read mode if you use database snapshots and you need to be using enterprise edition for this feature. The default for log shipping is restoring mode.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply