Post reply

Increase maximum filesize of database

  • April 29, 2006 at 4:50 am

    #169247

    Hi,

    I know how to set the maximum filesize of a single database on creation. However how do I change the maximum filesize of a database that is already existing.

    Something like ALTER DATABASE test maxfilesize = 200Mb??

    Thanks in advance,

    Erik

  • May 1, 2006 at 6:53 am

    #635077

    Try the link below for a walk through.  Hope this helps.

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/howtosql/ht_7_design_5gvt.asp

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • May 1, 2006 at 12:13 pm

    #635185

    Dear Gift,

    I found this walkthrough myself as well, however the thing I need is described but doesn't seem to work. It says that I should change autogrowth to "restricted growth to xxMB". However I can not change this value. I can only change the logical name and initial size.

    Any ideas?

    Erik

  • May 1, 2006 at 12:29 pm

    #635191

    You should be able to increase the file size, say you have 20megs as the size  if you click on it you can change it to 50 or 100megs depending on your disk space.  I usually do it with the Taskpad which is context sensitive so open your database and click at the top of Enterprise Manager.  Hope this helps.

    Kind regards,

    Gift Peddie

    Kind regards,
    Gift Peddie

  • May 2, 2006 at 12:47 am

    #635249

    Yep, you are right.

    Sorry, to botter you. I solved it now.

     

    Erik

Viewing 5 posts - 1 through 4 (of 4 total)

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