Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Maximum size of a database that SQL Server 2005 clustered allows Expand / Collapse
Author
Message
Posted Wednesday, September 9, 2009 12:42 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 4, 2012 9:40 AM
Points: 54, Visits: 132
Hi all,
I don't know if this is the right board to post this thread or not.
I know SQL 2005 allows up to the following size maximum for a database size, do you know or know if this is true for clustered environment as well? If not, do you know of a KB that gives the information for SQL server in a clustered environment?

Database size (32 bit) 524,258 terabytes (64 Bit) 524,258 terabytes

Thank you,
Post #785256
Posted Wednesday, September 9, 2009 12:59 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 20, 2015 6:40 AM
Points: 1,096, Visits: 2,634
I don't think there is any difference in the limits between clustered and non-clustered, but seriously are you getting anywhere close to 524,258 terabytes to start worrying about it????



_______________________________________________________________________
For better assistance in answering your questions, click here
Post #785271
Posted Wednesday, September 9, 2009 1:08 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 4, 2012 9:40 AM
Points: 54, Visits: 132
Quite frankly no, I had the following KBs that I always used for these occasions, however since they (management) brought up CLUSTERED for probably future data architecture optimization, i want to give them a definite answer. Most of cluster discussions online are usually regarding hardware ultimum size rather than datable allowed size.


http://technet.microsoft.com/en-us/library/ms143432(SQL.90).aspx
http://msdn.microsoft.com/en-us/library/ms143432.aspx

thank you,
Post #785284
Posted Wednesday, September 9, 2009 1:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, July 20, 2015 6:40 AM
Points: 1,096, Visits: 2,634
That's correct, you are more likely to hit hardware limitations than DB size limitations (for both clustered and non-clustered)....



_______________________________________________________________________
For better assistance in answering your questions, click here
Post #785313
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse