Re: sp_spaceused

From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 12/10/04 

Date: Fri, 10 Dec 2004 08:50:20 +0100

Transaction log? 

-- 
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"write2manish" <write2manish.1h0tp6@mail.webservertalk.com> wrote in message
news:write2manish.1h0tp6@mail.webservertalk.com...
>
> Hi,
>
> I am trying to solve a little puzzle. My database size is like 30 GB
> and i used sp_spaceused to find out which table in my database is the
> one using the max. size. After looking at all the table sizes using
> sp_spaceused the total came out to be only 2GB??? I am not sure who is
> using the other 28GB... Anyone any suggestions????
>
> Thanks in advance,
> Manish
>
>
>
> --
> write2manish
> ------------------------------------------------------------------------
> Posted via http://www.webservertalk.com
> ------------------------------------------------------------------------
> View this thread: http://www.webservertalk.com/message629190.html
>

Relevant Pages

  • sp_spaceused
    ... I am trying to solve a little puzzle. ... My database size is like 30 GB ... After looking at all the table sizes using ...
    (microsoft.public.sqlserver.server)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How critical is the transaction log file?
    ... Tibor Karaszi, SQL Server MVP ... file when you have only one file (no log file). ... circumstances it is supported to attach only an mdf file. ... > This development database that we're building does not have any 'user' ...
    (microsoft.public.sqlserver.tools)
  • Re: commiting the transaction log?
    ... Tibor Karaszi, SQL Server MVP ... been that the file growth (such as that by alter database or autogrowth) is ... Is that the reason for the log file (in the file system) having time stamp that is pretty old ... But even if I run the FULL backup, and then the T-log backup, I can see that ...
    (microsoft.public.sqlserver.server)
  • Re: "Do Not Allow Null" fields suddenly accept Nulls
    ... SQL Server MVP ... > to "Not Null" are now allowing nulls. ... > and the database saves it just fine. ... > message saying the field does not accept null data. ...
    (microsoft.public.sqlserver.server)