Post reply

Can I resize tempdb to a smaller size - then bounce server later to take affect?

  • January 15, 2008 at 9:59 am

    #69418

    Currenty we have a sql2000 server with a tempdb of 15GB (it is set that way). It no longer needs to be that large. I would like to set it to 10GB while it is up and running. Later in the week we will bounce servers after applying patches and I would like it to take affect then. Is this do-able? Since we are bouncing anyway - I am trying to avoid bringing down SQL or setting it to single user mode.

  • January 15, 2008 at 10:46 am

    #768243

    I don't think its possible. You have to restart mssql services to resize tempdb. Its possible with other user databases but not with tempdb. the way to do this is in this article.

    http://support.microsoft.com/kb/307487

    SQL DBA.

  • January 15, 2008 at 11:21 am

    #768251

    Thanks Sanjay.

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

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