SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 always on
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

heliang
Starting Member

34 Posts

Posted - 07/16/2013 :  16:33:37  Show Profile  Reply with Quote
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

USA
36787 Posts

Posted - 07/16/2013 :  16:42:33  Show Profile  Visit tkizer's Homepage  Reply with Quote
Yes. It's shocking at first.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

heliang
Starting Member

34 Posts

Posted - 07/16/2013 :  16:46:58  Show Profile  Reply with Quote
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!
Go to Top of Page

heliang
Starting Member

34 Posts

Posted - 07/16/2013 :  16:50:09  Show Profile  Reply with Quote
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?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36787 Posts

Posted - 07/16/2013 :  17:36:58  Show Profile  Visit tkizer's Homepage  Reply with Quote
If you use a secondary replica for reporting or the likes, then yes it needs to be licensed. I believe backups are okay without a license. Due to a limitation with backups, we are backing up the primary only.

Have you already implemented page and/or row compression?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

heliang
Starting Member

34 Posts

Posted - 07/17/2013 :  11:31:55  Show Profile  Reply with Quote
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?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36787 Posts

Posted - 07/17/2013 :  17:32:42  Show Profile  Visit tkizer's Homepage  Reply with Quote
http://msdn.microsoft.com/en-us/library/hh245119.aspx

quote:

Backup Types Supported on Secondary Replicas
BACKUP 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 Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000