Maximum size of a database that SQL Server 2005 clustered allows

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » Maximum size of a database that SQL Server...

Maximum size of a database that SQL Server 2005 clustered allows

Rate Topic

Display Mode

Topic Options

Author

Message

EllieDBA

Posted Wednesday, September 09, 2009 12:42 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, January 04, 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

Richard M.

Posted Wednesday, September 09, 2009 12:59 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 1,058, Visits: 2,575

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

EllieDBA

Posted Wednesday, September 09, 2009 1:08 PM

Valued Member

Group: General Forum Members
Last Login: Wednesday, January 04, 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

Richard M.

Posted Wednesday, September 09, 2009 1:31 PM

Ten Centuries

Group: General Forum Members
Last Login: Yesterday @ 11:42 AM
Points: 1,058, Visits: 2,575

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 »

Permissions