Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alimuumin
Starting Member
7 Posts |
 Posted - 2005-09-12 : 04:13:02
|
| I have a large database currently using up 5GB of space -- I deleted some records of a table and the free space is increased.So the question is, if I delete some of the data from this tablewill the database size decrease? Is there anything else I can do toreduce the size of the database?Thank you so very much for any help with this!Regards Mr. MuminThanks All, |
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2005-09-12 : 05:15:41
|
| check SHRINKFILE in BOL.------------------------I think, therefore I am - Rene Descartes |
 |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-09-12 : 06:16:11
|
| Why do you want to decrease the database size?-------Moo. :) |
|
|
|
alimuumin
Starting Member
7 Posts |
Posted - 2005-09-13 : 01:11:51
|
| The database is increasing day by day, and it grow up untill you get the error "you have Insufficient disk space" becouse the hard disk is full.That is why i am trying to reduce the database size.Regards Mr. MuminThanks All, |
|
|
|
paulrandal
Yak with Vast SQL Skills
899 Posts |
Posted - 2005-09-13 : 01:31:55
|
quote:
Originally posted by alimuumin
The database is increasing day by day, and it grow up untill you get the error "you have Insufficient disk space" becouse the hard disk is full.That is why i am trying to reduce the database size.
Sounds like you need a bigger disk if you're continually running out of disk space. Shrinking is not the answer as the database will just grow again - so by shrinking you've wasted a bunch of resources and caused allocation fragmentation.Paul RandalDev Lead, Microsoft SQL Server Storage Engine(Legalese: This posting is provided "AS IS" with no warranties, and confers no rights.) |
|
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-09-13 : 04:32:12
|
quote:
Originally posted by alimuumin
The database is increasing day by day, and it grow up untill you get the error "you have Insufficient disk space" becouse the hard disk is full.That is why i am trying to reduce the database size.
That's because people are using the database and storing information in it. As Paul says, it sounds like you need to add some more disk space to your server.You cannot store information without using up space.-------Moo. :) |
|
|
|
|
|
|
Decreasing database size