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 |
|
zaty2405
Yak Posting Veteran
58 Posts |
 Posted - 2010-02-25 : 00:46:16
|
| Hi,Here is the resul of sp_spaceused run against my databasedatabase_name database_size unallocated space Premier 16319.19 MB 152.80 MB reserved data index_size unused 14630280 KB 1804560 KB 333224 KB 12492496 KBFrom the result, it shows database_size= 16319.19 MB and data = 1804560 KBDoes this means that my database size is actually 1804560 KB ?How do I make this database smaller? Will dbcc shrinkfile help to reduce the size?Thanks |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 02:18:47
|
| I think your database is 2,137,784 KB - i.e. either Data + Index or Reserved - Unused.Either way, unused seems to be 12GB of your 16GB database, so I reckon you should be shrinking it to a more realistic size.You cannot shrink it smaller than the "initial size", so check first that that hasn't been set to 16GB!! |
 |
|
|
zaty2405
Yak Posting Veteran
58 Posts |
Posted - 2010-02-25 : 04:12:29
|
| Thanks Kristen.But why does enterprise manager showing use space as 16 GB ?even sp_spaceused also indicate the same |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 05:48:54
|
| File is preallocated to 16GB (either it has that setting for "initial size", or there was once more data that has now been deleted, or (perhaps) something needed some working-space and that expanded the files.Does that make sense, or am I answering the "wrong question"? |
|
|
|
zaty2405
Yak Posting Veteran
58 Posts |
Posted - 2010-02-25 : 09:40:30
|
| yes. you did answer my question thanks.so if the initial size is 16GB , then theres no way to shrink it to smaller size? If so, whats the alternative to make the database smaller?Thanks Kristen |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2010-02-25 : 10:11:17
|
| If you use SHRINK does it tell you that there is 12GB free space and offer to allow you to reclaim it?(You would probably need to use the "Move pages to front of file" option) |
|
|
|
thewebhosting
Starting Member
17 Posts |
Posted - 2010-03-24 : 18:11:53
|
| Hi,You can either shrink the database file or increase the space for your database from the server administrative access. You may not have an access of the admin of the server. Hence, you are not able to view the database space from the enterprise manager. In this case, you need to contact your MS SQL database service provider t get exact database space and shrink the database file. |
|
|
|
|
|
|
|
|
database space issue