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-05-07 : 08:09:43
|
| Nandip writes "Hello Friends, I am having a problem when reducing the size of my database.I am working in an ISP and the size of our database growsat a considerable rate. As a result we decided to move the oldinformation in the table in a summarize ways. Thus a number of records were removed from the database.Before moving the records the size of my database was around 8 GB and after moving the records the size was same. We tried to shrink the database as well as files with the respect commands and proper parameter.i.e DBCC SHRINKDATABASE and DBCCSHRINKFILE , but even after doing so there was no much change in the size of our transaction log. The log file(.ldf) has now grown upto 8.5 GB while thephysical file(.mdf) is 1.5 GB. So we are nearing to the full harddisk space day by day. I also noticed that even the log file of tempdb database has been grown upto 1 GB.I read the articles that you have posted in you side andtried to implement it but in vain.Please let me know what exact steps should i take to solve this problem.If you have any place where i would be able to get the information then please let me know.Thank you." |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
Konrad
Starting Member
2 Posts |
|
|
|
|
|
Unable to Shrink Database Size 