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 |
|
heliang
Starting Member
38 Posts |
 Posted - 2013-07-16 : 16:33:37
|
| I am reading new always on feature for 2012 and come up this question. Since each replica can treat as a sigle instance, does this meant that I will double or trible my storage?storage for singe instance X number of replicas |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
heliang
Starting Member
38 Posts |
Posted - 2013-07-16 : 16:46:58
|
| Well... This will require lots of storage.. If I have a intance which is using 1TB with always on and 3 replicas, I will need 3TB for the storage... This is too much! |
 |
|
|
heliang
Starting Member
38 Posts |
Posted - 2013-07-16 : 16:50:09
|
| How about licensing? if I have two replicas, one for read and one for write, then I will need to license both replicas, right? If the second one replica only for backup, I will not need to license it, right? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
heliang
Starting Member
38 Posts |
Posted - 2013-07-17 : 11:31:55
|
| I have not implement page and/or row compression yet. May I ask what is the limitation that is preventing you backup the secondary replica? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-07-17 : 17:32:42
|
http://msdn.microsoft.com/en-us/library/hh245119.aspxquote:
Backup Types Supported on Secondary ReplicasBACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it is executed on secondary replicas. Note that copy-only backups do not impact the log chain or clear the differential bitmap.Differential backups are not supported on secondary replicas.BACKUP LOG supports only regular log backups (the COPY_ONLY option is not supported for log backups on secondary replicas).A consistent log chain is ensured across log backups taken on any of the replicas (primary or secondary), irrespective of their availability mode (synchronous-commit or asynchronous-commit).
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
|
|
always on