Re: DB Space

From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 07/13/04

  • Next message: Jim Young: "Re: msde 7" 
    Date: Tue, 13 Jul 2004 09:21:29 +0530

    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
  • Next message: Jim Young: "Re: msde 7"

    Relevant Pages

    • Re: DB Space
      ... > "Hari Prasad" wrote: ... >> Can you execute the below command to ghet the actual database size. ...
      (microsoft.public.sqlserver.msde)
    • RE: Event ID 447
      ... Please made a backup for Exchange database first. ... Please run the eseutil /mh command to see if the mailbox store is clean ... Microsoft CSS Online Newsgroup Support ...
      (microsoft.public.windows.server.sbs)
    • 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: Sharepoint Database falling over event 1000
      ... Microsoft Small Business Server Support ... > I Have Just run the SQL command from the command Line, ... > affected)1> exitDoes this say the database is Ok?If so why since we loaded ... > I/O operation has been aborted because ofeither a thread exit or an ...
      (microsoft.public.windows.server.sbs)
    • Re: Too many args when running a stored procedure
      ... Perhaps you have a duplicate definition of "AddAJob" in the master database schema. ... you don't show that you are associating the connection object with ... >> it with the command object. ... >>> @Rate money ...
      (microsoft.public.dotnet.languages.vb)