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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-09-08 : 07:29:56
|
| Mohan writes "I had one problem that was my Databse size has almost gone upto 3GB.The log file is small no problem with it.But i have table in data which have husge dat in it from year 2001 one.I am in no need of this data from 2001 one whihc is stored in a particualr table called say X.I want data only for this financial year.I also i have one question that is after dropping unnecessary table from the Databse does the size of the MDF file decrease.If not then the unnecessary free space can this be removed.Pls fell to mail me at my mail is bluekite_11@yahoo.co.inMohan" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-08 : 12:17:41
|
| Run the delete to delete the 2001 data, then run sp_spaceused @UPDATEUSAGE = 'TRUE'.Tara |
 |
|
|
bluekite_11
Starting Member
4 Posts |
Posted - 2003-09-11 : 04:38:27
|
| Hi!!! Tara Thank u fro ur response to my problem.But he command u gave to run sp_spaceused @UPDATEUSAGE = 'TRUE'. it just dispalys the space occupied and unalloted space of the Database can u tell me how.Bcos see after deleting Old year data from the Db the Db size should be reduced.Morever what i got after deleting the data from the table was my Databse size increased.Can u guide me how can i reduce the db size |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-11 : 11:58:00
|
| What increased though? The log file or the data file? What is your database recovery model set to? Have you run DBCC SHRINKDATABASE or DBCC SHRINKFILE to reduce the size of the files?Tara |
|
|
|
bluekite_11
Starting Member
4 Posts |
Posted - 2003-09-15 : 03:29:37
|
| THe MDF file increases...and yes i ran shrinkdatabase but nothing worked out much... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-15 : 11:53:31
|
| But isn't the MDF file in use because the application is running? How big was the table that you dropped? To further reduce the size of the MDF file, you will need to delete more data.Tara |
|
|
|
|
|
|
DB free space