Re: DB Space

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 17:51:25 -0400

Looks like ~900 MB to me.

Where did you see "It shows 0 space left on the DB"? 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Niles" <Niles@discussions.microsoft.com> wrote in message
news:98FD70CA-9DBA-4D4C-915B-C3EBAEDA731E@microsoft.com...
> 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

  • Re: C# command doesnt time out appropriately...why?
    ... record in our database that matches the search criteria, ... only by increasing the timeout in our VB application, little by little, ... I'm basically trying to execute the command, which of course is a call ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Set Restricted_User
    ... to the database, the connection may drop as the database ... the other users but for the app that executes the command to ... Then execute the command and then try ...
    (microsoft.public.sqlserver.security)
  • Get Table and Field Names
    ... To get a list of available tables in current database, ... execute the following command: ... EXEC sp_msforeachtable @command1='print REPLACE(REPLACE ... properties for a table, execute the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: DB Space
    ... Can you execute the below command to ghet the actual database size. ... use dbname ...
    (microsoft.public.sqlserver.msde)
  • Re: Static Functions in a Multi Threaded App
    ... depending on how you are allocating the connection (do you have ... do you execute more than one command ... I am logging to a database. ...
    (microsoft.public.dotnet.languages.csharp)