January 17, 2009 at 7:35 am
Dear Friends,
We have our personalized database for our company, which is running on SQL 2000 server. As we are observing, MDF file size is growing rapidly, It was around 1 GB in 2006 and now it 9.33 GB (As of now). When i check on the tables (totally around 192) and around of 1,20,000 records in only 5 tables. We are not aware of why that DB is growng rapidly.
Please any one suggest
January 17, 2009 at 8:32 am
Run sp_spaceused on the database and on each of the tables in the database. That should show you where the space is been used, or if it's free space within the DB.
How big are your backups?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
January 17, 2009 at 3:39 pm
check your column data types, growing 8GB in 3 years doesnt seem too wrong depending on the data you are storing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply