Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    38

    Unanswered: DB space available 0.00Mb

    Hi there,

    I had originally set a max file size with restricted growth as we didn't think it would reach past it's limit. However, when I checked today it said space available 0.00Mb.

    Two questions I have are:

    (1) Would running out of space cause any problems to the database
    (2) Can I simply just set this to unrestricted or set a higher limit and then the DB will continue to grow again?

    Thanks

    S

  2. #2
    Join Date
    Feb 2005
    Posts
    78
    Um, yes. And yes if you have space on the disk.

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by sclark77
    (1) Would running out of space cause any problems to the database
    This will always result in inserts/updates (and usually deletes) failing as there is no space available to push around the data.

    Selects will usually continue to function normally.

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Jan 2003
    Location
    India
    Posts
    523
    Quote Originally Posted by sclark77

    (1) Would running out of space cause any problems to the database
    From BOL:


    During recovery, it is a rare but possible occurrence for the server to require additional log or data space. If additional space is unavailable and either the log or data files cannot grow, the server:

    1.Reports error message 9002 or 1105 in the Microsoft® SQL Server™ error log.
    2. Marks the database as suspect.
    3.Takes the database offline.

  5. #5
    Join Date
    Mar 2004
    Posts
    114
    Have you tried first a :
    Code:
    DBCC UPDATEUSAGE ('mydb')
    with mydb you database name ?

    This reports and corrects inaccuracies in the sysindexes table, which may result in incorrect space usage reports by the sp_spaceused system stored procedure.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •