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 |
|
jay53140
Starting Member
10 Posts |
 Posted - 2003-02-05 : 15:10:36
|
| After changing the space allocated to a high number in the database properties, how can you change it back? Right now it is set on 28 MB, I want it to be somewhere under 5 MB. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-05 : 15:24:36
|
| DBCC SHRINKDATABASESee BOL for details. |
 |
|
|
jay53140
Starting Member
10 Posts |
Posted - 2003-02-05 : 15:38:19
|
| I have tried DBCC SHRINKDATABASE but it doesn't change the space allocated. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-05 : 15:45:17
|
| Try DBCC SHRINKFILE and specify the file size that you want it shrunk to (5 in your case). Also use the TRUNCATEONLY option with the DBCC SHRINKFILE command. |
|
|
|
|
|
|
Space allocated....