Post reply

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

  • November 20, 2008 at 10:12 am

    #194209

    Is anyone knows How to change available size in the database? I have 0% after db was shrinked. How much % I change to?

  • November 20, 2008 at 10:25 am

    #901182

    Depends. How big is your database? How fast does it grow?

    You shouldn't ever shrink a database. By doing so you've fragmented all of your indexes. I would strongly suggest you rebuild them all asap.

    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

  • November 20, 2008 at 10:32 am

    #901187

    How you do that?

  • November 20, 2008 at 10:33 am

    #901189

    This is a cross posting - it appears under "Development" as well but with a little less information.

    In addition to GilaMonsters advice can you:

    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]

  • November 20, 2008 at 10:38 am

    #901193

    yulichka (11/20/2008)

    How you do that?

    How do you do what? Rebuild indexes?

    Look up ALTER INDEX in books online.

    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

  • November 20, 2008 at 12:06 pm

    #901228

    if you're uncomfortable with T-SQL you can via management studio drill down through tables to the index level and right click then select rebuild all

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 20, 2008 at 12:23 pm

    #901240

    Thank you This is 2000 and there is no option for that.

  • November 20, 2008 at 12:30 pm

    #901243

    yulichka (11/20/2008)

    Thank you This is 2000 and there is no option for that.

    What do you expect? You posted your problem in a SQL Server 2005 forum, you are going to get a SQL Server 2005 answer.

  • November 20, 2008 at 1:03 pm

    #901255

    Thank you::D

  • November 20, 2008 at 2:02 pm

    #901284

    yulichka (11/20/2008)

    Thank you This is 2000 and there is no option for that.

    Then read up on DBCC DBREINDEX

    Please post in the correct forum from now on.

    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 10 posts - 1 through 10 (of 10 total)

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