Post reply

Change properties of msdb database

  • December 20, 2004 at 7:17 am

    #91892

    I have noticed that the msdb database is set to autogrow by 1 MB !

    Can I change this on the fly to something like autogrow by 10% ? or do I need to stop and restart the SQL Server Service?

    I've had a quick look on google but couldn't find anything on the subject.

    Thanks

    Carl

     

  • December 20, 2004 at 9:47 am

    #534491

    For SQL Server 2000 this is the default setting I believe.  You can change this to increment by a percentage or set number of megabytes on the fly and you don't need a restart.  If you do this with your user databases, make sure you have enough disk space to handle the additional growth.  Hope this helps.

    My hovercraft is full of eels.

  • December 20, 2004 at 9:52 am

    #534494

    Thanks for the reply.

    I am aware of the autogrowth setting.

    I just wasn't sure whether or not I would need to stop and start SQL Server Service.

    I will make sure I take a backup of the current msdb before I change the setting

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

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