DBCC Shrinkdatabase & DBCC Shrinkfile - Part 2

I have already shrunk the log but the free space of
14000MB is in the data file which can be seen under
the 'Space Allocated' TAB. Does anyone know a way around
it?Have you use the TRUNCATEONLY option in the DBCC
SHRINKDATABASE and SHRINKFILE.
If it's not working too, I'm sorry to ask but have you
ever backup the database and the transaction log ?
It's mostly important to backup your transaction log if
you want to truncate it, because it will truncate the
inactive portion of the log and leave the active one (it
became inactive portion if you already do the backup).
So the point is, do the backup than you can truncate it,
and after that you can shrink it if you want to.
Please read the books online, it contains a lot
information about it. Hope it helps.. :)
Regards,
Jono Indrawijaya - MCDBA
PT. eBiz Cipta Solusi - Microsoft Certified Partner
Indonesia
>--Original Message--
>I have already shrunk the log but the free space of
>14000MB is in the data file which can be seen under
>the 'Space Allocated' TAB. Does anyone know a way around
>it?
>.
>

dbcc reports different size than shown in database properties

In sql 2k, I've been looking at size and autogrowth, and some issues have
come up.
In my database properties, general tab, I see size 9118mb, space avail
1372mb. However, when I run
dbcc showfilestats
I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free space
of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge discrepancy?
Perhaps the log is counted in the size, but surely that should not affect
space available.
Jeremy
Try running DBCC UPDATEUSAGE and see if that helps.
Andrew J. Kelly SQL MVP
"JeremyGrand" <jeremy@.ninprodata.com> wrote in message
news:eUDnqux7GHA.1560@.TK2MSFTNGP04.phx.gbl...
> In sql 2k, I've been looking at size and autogrowth, and some issues have
> come up.
> In my database properties, general tab, I see size 9118mb, space avail
> 1372mb. However, when I run
> dbcc showfilestats
> I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free
> space of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge
> discrepancy? Perhaps the log is counted in the size, but surely that
> should not affect space available.
> Jeremy
>

dbcc reports different size than shown in database properties

In sql 2k, I've been looking at size and autogrowth, and some issues have
come up.
In my database properties, general tab, I see size 9118mb, space avail
1372mb. However, when I run
dbcc showfilestats
I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free space
of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge discrepancy?
Perhaps the log is counted in the size, but surely that should not affect
space available.
JeremyTry running DBCC UPDATEUSAGE and see if that helps.
--
Andrew J. Kelly SQL MVP
"JeremyGrand" <jeremy@.ninprodata.com> wrote in message
news:eUDnqux7GHA.1560@.TK2MSFTNGP04.phx.gbl...
> In sql 2k, I've been looking at size and autogrowth, and some issues have
> come up.
> In my database properties, general tab, I see size 9118mb, space avail
> 1372mb. However, when I run
> dbcc showfilestats
> I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free
> space of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge
> discrepancy? Perhaps the log is counted in the size, but surely that
> should not affect space available.
> Jeremy
>

dbcc reports different size than shown in database properties

In sql 2k, I've been looking at size and autogrowth, and some issues have
come up.
In my database properties, general tab, I see size 9118mb, space avail
1372mb. However, when I run
dbcc showfilestats
I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free space
of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge discrepancy?
Perhaps the log is counted in the size, but surely that should not affect
space available.
JeremyTry running DBCC UPDATEUSAGE and see if that helps.
Andrew J. Kelly SQL MVP
"JeremyGrand" <jeremy@.ninprodata.com> wrote in message
news:eUDnqux7GHA.1560@.TK2MSFTNGP04.phx.gbl...
> In sql 2k, I've been looking at size and autogrowth, and some issues have
> come up.
> In my database properties, general tab, I see size 9118mb, space avail
> 1372mb. However, when I run
> dbcc showfilestats
> I get an allocated size of 7808mb (TotalExtents*64/1024.00), and free
> space of 189mb ((TotalExtents-UsedExtents)*24/1024). Why this huge
> discrepancy? Perhaps the log is counted in the size, but surely that
> should not affect space available.
> Jeremy
>