March 9, 2017 at 11:54 am
I learned that replikation gives you workable copies and mirroring only a backup in case of the "main" database fails.
Now I have heard of AlwaysOn that seems to be mirroring 2.0.
Can you say that it replaces both replication and mirroring?
March 9, 2017 at 12:27 pm
replication is carried out at the individual object level within a database, it's nothing like mirroring or availability groups.
AlwaysOn availability groups are essentially an extension of database mirroring. AG's allow multiple secondaries and support read only mode and backup offload ability
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 9, 2017 at 1:09 pm
Perry Whittle - Thursday, March 9, 2017 12:27 PMreplication is carried out at the individual object level within a database, it's nothing like mirroring or availability groups.
AlwaysOn availability groups are essentially an extension of database mirroring. AG's allow multiple secondaries and support read only mode and backup offload ability
Thanks!
What does backup offload ability mean?
March 10, 2017 at 6:56 am
It means you can take backups on your secondary (read-only) replica instead of on the primary (read-write).
March 11, 2017 at 9:33 am
Beatrix Kiddo - Friday, March 10, 2017 6:56 AMIt means you can take backups on your secondary (read-only) replica instead of on the primary (read-write).
Aha, ok. Thanks alot!
March 15, 2017 at 11:14 pm
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of primary databases and one to eight sets of corresponding secondary databases. Secondary databases are not backups. Continue to back up your databases and their transaction logs on a regular basis.
For more information visit: http://www.sqlserverlogexplorer.com/alwayson-availability-groups-failover/
March 16, 2017 at 5:33 am
johnwalker10 - Wednesday, March 15, 2017 11:14 PMSecondary databases are not backups. Continue to back up your databases and their transaction logs on a regular basis.For more information visit: http://www.sqlserverlogexplorer.com/alwayson-availability-groups-failover/
quite right, but you can offload your backup tasks to a readable secondary rather than imapcting the primary
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply