Re: DB Space

From: Niles (Niles_at_discussions.microsoft.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 13:04:36 -0700

These are the results
Database_size = 1881.06 MB
Unallocated space = 0.07 MB

Reserved 1925112 KB
Data 1023400 KB
Index_size 8192 KB
Unused 893520 KB

Does the last one mean that I still have about 8 MB of free space?
Thanks for your help

"Hari Prasad" wrote:

> Hi,
>
> Can you execute the below command to ghet the actual database size.
>
> use dbname
> go
> sp_spaceused @updateusage='true'
>
> -- Execute the above command when database have very less access. Because
> the above command internally
> execute DBCC UPDATEUSAGE on all the tables in the database with Shared
> locks.
>
>
> --
> Thanks
> Hari
> MCDBA
> "Niles" <Niles@discussions.microsoft.com> wrote in message
> news:7957D013-1F3E-43D5-B28A-CF6FDBE1A455@microsoft.com...
> > I have an MSDE database that has reached 1880.06 MB and the Tlog is about
> 1MB. It shows 0 space left on the DB. What can I do to get some more
> space? Would shrinking the DB accoplish the goal?
> >
> > Thanks
>
>
>

Relevant Pages
Loading