Re: The size of the DB

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 08/30/03

  • Next message: Mary Chipman: "Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'"
    Date: Fri, 29 Aug 2003 20:29:52 -0400
    
    

    I guess I should also mention you can get the size of the db from using
    sp_helpdb.

    -- 
    Andrew J. Kelly
    SQL Server MVP
    "Jose Martinez" <jomapa01@hotmail.com> wrote in message
    news:0c1b01c36e83$8a5c6cf0$a001280a@phx.gbl...
    Andrew
    I apreciate your soon answer and your help !!
    Regards
    José Martinez
    Mexico City
    >-----Original Message-----
    >Well your db size is the sum of all the files.  You can
    check out sysfiles
    >in the master db for the size of those.
    >
    >-- 
    >
    >Andrew J. Kelly
    >SQL Server MVP
    >
    >
    >"Jose Martinez" <jomapa01@hotmail.com> wrote in message
    >news:030001c36e78$990c5900$a601280a@phx.gbl...
    >> Hi:
    >>
    >> Could any one tell me in wich system table (sysobjects,
    >> sysnames, etc) is stored the actual size of the Data
    Bases
    >>
    >> Regards
    >
    >
    >.
    >
    

  • Next message: Mary Chipman: "Re: Microsoft OLE DB Provider for ODBC Drivers error '80004005'"

    Relevant Pages

    • Re: DTS - Triggers and Defaults Not Firing
      ... > Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)> www.SQLDTS.com - The site for all your DTS needs. ... > "Andrew J. Kelly" wrote in message ... The columns are nullable that are to>> be updated via insert and update triggers. ...
      (microsoft.public.sqlserver.dts)
    • Re: Recovering SQL Server 2000 database without a backup
      ... >>Andrew J. Kelly ... >>SQL Server MVP ... >>> database and I don't have a recent backup. ...
      (microsoft.public.sqlserver.tools)
    • Re: reindex or update stat
      ... change in the way the queries are run. ... Andrew J. Kelly ... SQL Server MVP ... > I have a database that will have couple thousands row inserted normally, ...
      (microsoft.public.sqlserver.server)
    • Re: database maintenance for companies that run 24/7
      ... fixes, windows update, etc. ... Aaron Bertrand ... SQL Server MVP ... "Andrew J. Kelly" wrote in message ...
      (microsoft.public.sqlserver.server)
    • Re: time out (used to work fine and was indexed)
      ... Andrew J. Kelly ... SQL Server MVP ... "mike" wrote in message ... > 300,000 records and it worked, albeit a little slower than ...
      (microsoft.public.sqlserver.programming)