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 |
|
WildMan
Starting Member
22 Posts |
 Posted - 2002-11-08 : 15:40:44
|
| Hello,I ran the DBCC SHRINKDATABASE on one of my databases and instead of shrinking the size it increased the size by about 140.I ran this:DBCC SHRINKDATABASE (dbname,5)Before the database size was around 540 and now it is at 680. What happened? I tried running it again but it still stays at 680. I had run the command on my db about a 1 ago and it worked fine but this time it did not.Any ideas??Thanks,Joey |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-08 : 17:41:22
|
| Maybe a transaction was running at the same time and caused the database to grow.If that's not it, try DBCC SHRINKFILE instead. See if that works for you. I don't have an explanation for your problem, but maybe the other command will work for you. |
 |
|
|
|
|
|
Shrink Database command increased the size