available size in the database

  • Is anyone knows How to change available size in the database?

  • One can ask why you want to increase available size, I can only assume that when your DB was created autogrowth (If memory serves me correctly Autogrowth enabled is the default for a new DB) was not selected or have you not checked that DB property? To do so in SSMS right click on the DB in question, in the menu that appears select Properties, in the left pane of the properties window select Files, and look at the autogrowth column. Post your results to allow someone to assist you further.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Please don't cross post. It just wastes people's time and fragments replies.

    No more replies here please. Replies to:

    http://www.sqlservercentral.com/Forums/Topic605967-146-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply