Database Size

[jwsop]

Hi..
My database data file are over 2.1 Gbs now. can anyone tell me is my data file too big?? or not safe?? or there's a limite for MSSQL 2000. my last choice are move some data to another database. but i have consider the report i have to make. so i really dont want to do that. can anyone advice. thanks

[MAK]

SQL Server 2000 (not desktop edition) can handle a database size of 1,048,516 TB.

use SP_spaceused on the database and see how much free space u have.

Do a checkpoint, dbcc shrinkdb and shrinkfile and see how much size your database really uses.

is it safe? nice question. depends on the following.

Where your DB is located? on a RAID 5 HDD array or on SAN or on a standalone HDD.
How often you take backups and how sensitive the data is.

[jwsop]

thanks for the information. that really help alot...

[MAK]

FYI.

SQL Server capacity
---------------------
http://msdn.microsoft.com/library/de...ar_ts_8dbn.asp

RAID
-----
http://www.networkbuyersguide.com/search/294003.htm

http://www.raidionsystems.com/html/raid_levels.htm

Backup
-------
http://www.dell.com/us/en/biz/topics...q00-martin.htm

http://msdn.microsoft.com/library/de...kprst_9zcj.asp


VLDB tuning and performance
----------------------------
http://www.sql-server-performance.com/vldb.asp

http://www.sql-server-performance.com/filegroups.asp

SQL Server 2000 scalability
---------------------------
http://www.microsoft.com/sql/techinf...00/rosetta.doc

[jwsop]

thanks for the information. that really help alot...