How can I compact MS SQL 2000 Database?

Now my database is contain a big size and still grow up. I think may I can compact it to small size like ms-access.
How can I compact MS SQL 2000 Database?You can shrink the databse by any of the following option.

1.You can use the syntax dbcc shrinkdb <databasename> on query analyzer

or

2.selse sqlserver -> enterprise manager ->select the database -> right clik this and select the option shink

for more information u can use books online shrink database option|||To prevent the database from unwanted growth, you can set the 'Auto shrink' option (in Enterprise Manager, right click on your database, choose properties, select options tag and check the auto shrink option).

How big a SQL database can be

How big an SQL database can grow to be? There is any limitation. My database is 4 GB so far (MDF file) every month is growing around 100 MB, what's the limit?
Thanks
AlSomething like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
--
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al

How big a SQL database can be

How big an SQL database can grow to be? There is any limitation. My database is 4 GB so far (MDF file) every month is growing around 100 MB, what's the limit?
Thanks
Al
Something like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al
|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al

How big a SQL database can be

How big an SQL database can grow to be? There is any limitation. My database
is 4 GB so far (MDF file) every month is growing around 100 MB, what's the
limit?
Thanks
AlSomething like a million terrabytes or so. You don't have enough disks to
even come close to even the practical limits.
Andrew J. Kelly SQL MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al|||The Maximum Capacity Specifications topic in the SQL Server Books Online
states the max database size is 1,048,516 TB, except for MSDE (which has a
2GB limit).
You've got a bit to go :-)
Hope this helps.
Dan Guzman
SQL Server MVP
"Albert Pascual" <AlbertPascual@.discussions.microsoft.com> wrote in message
news:23D19618-4E8A-44E2-86AD-F71E9641AB02@.microsoft.com...
> How big an SQL database can grow to be? There is any limitation. My
database is 4 GB so far (MDF file) every month is growing around 100 MB,
what's the limit?
> Thanks
> Al