September 22, 2003 at 9:30 am
Does anyone know the maximum device size for SQL Server 6.5.
(Yes I know I need to get this database off of it! )
September 22, 2003 at 2:57 pm
Yikes, I'd check the BOL for 6.5. I suspect this is in the terabyte range though. I thought I had a 100GB db sometime ago. I know I had a 50GB one.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 23, 2003 at 1:32 am
quote:
Yikes, I'd check the BOL for 6.5. I suspect this is in the terabyte range though. I thought I had a 100GB db sometime ago. I know I had a 50GB one.
From BOL for SQL6.5:
quote:
SQL Server can manage up to 32,767 databases, each of which can be up to 1 TB in size. Each database can have a maximum of 32 device fragments. Each time you use CREATE DATABASE or ALTER DATABASE to allocate space on a database device, that allocation represents a device fragment and is entered as a row in the sysusages system table.
Which is nice and simple, but doesn't quite answer the question...
quote:
The total number of physical devices that can be used or the total size of each logical device is not limited (this is limited by the physical device(s) used, with an absolute maximum of 32 GB for each logical device).
and, with a maximum of 32 logical devices for each database, that's where the 1TB figure comes in.
Thomas Rushton
blog: https://thelonedba.wordpress.com
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply