How big is big

How big can a database be in a sql 2000 and in SQL 7.0' Is it 6 gig the
largest size!No, try 1,048,516 TERABYTES. That's the figure in Books Online... Now,
where are we going to find a disk big enough to test that limit?
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:FA13B9D5-5DED-48A5-99C7-5A27B35BBF9B@.microsoft.com...
> How big can a database be in a sql 2000 and in SQL 7.0' Is it 6 gig the
> largest size!|||MS posts white papers detailing DBs as big as 10TB. But in general even
with exceptional hardware anything bigger than 500GB takes careful planning
and a significant change in mind set. Of course a poorly designed 20GB DB
could also be a handful.
Oh if only my DBs were 6GB again...those where the days...
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:FA13B9D5-5DED-48A5-99C7-5A27B35BBF9B@.microsoft.com...
> How big can a database be in a sql 2000 and in SQL 7.0' Is it 6 gig the
> largest size!|||Thanks guys, that is what I thought but their are people out here that only
work on access db! RAY so if I look at the white papers for sql 2000 I will
find this information
"Ray" wrote:

> MS posts white papers detailing DBs as big as 10TB. But in general even
> with exceptional hardware anything bigger than 500GB takes careful plannin
g
> and a significant change in mind set. Of course a poorly designed 20GB DB
> could also be a handful.
> Oh if only my DBs were 6GB again...those where the days...
>
> "Brian" <Brian@.discussions.microsoft.com> wrote in message
> news:FA13B9D5-5DED-48A5-99C7-5A27B35BBF9B@.microsoft.com...
>
>|||MSAccess has its place but it's not designed or intended to be a enterprise
class database. Calling it a workgroup class database is pushing it.
Here's the classic MS whitepaper on how to build a 10TB database.
http://www.emulex.com/products/white/fc/humangenome.pdf
I also ran across this basic comparison.
http://www.mssqlcity.com/Articles/C...SQLvsAccess.htm
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:1252C739-5BD1-44FF-B4C2-34792C999AB0@.microsoft.com...[vbcol=seagreen]
> Thanks guys, that is what I thought but their are people out here that
> only
> work on access db! RAY so if I look at the white papers for sql 2000 I
> will
> find this information
> "Ray" wrote:
>