Post reply

Tempdb backup

  • May 27, 2008 at 8:15 am

    #207752

    Hey Guys,

    I would like to know if I can backup tempdb and also how to enable autoshrink option in sql server 2005. I tried using SSMS and going to options and tried to enable tempdb which is in simple recovery mode but it was throwing error. Any help would be gr88 😀

  • May 27, 2008 at 8:46 am

    #820586

    You can not backup TempDB, and you should try to steer clear from auto-shrink. It is much better to size your databases accordingly from the start to allow you to use autogrow sparingly, and not use shrink. Shrinking will eventually cause fragmentation.

    "Got no time for the jibba jabba!"
    -B.A. Baracus

  • May 27, 2008 at 9:32 am

    #820618

    You can not backup TempDB, and you should try to steer clear from auto-shrink. It is much better to size your databases accordingly from the start to allow you to use autogrow sparingly, and not use shrink. Shrinking will eventually cause fragmentation.

    -AH

    Thanks,

    But, what would be the problem with fragmentation? Will it effect the performance? Also, even if I have allocate enough space for tempdb, how can I deallocate the memory which is not being used.

  • May 28, 2008 at 11:21 am

    #821344

    why do you want to backup tempdb?

  • May 28, 2008 at 12:18 pm

    #821376

    Regarding the backup, I figured it out thats not a good option, one question I have is how to enable the autoshrink option to true for tempdb. I was not sure if we can enable this option.

    thanks

  • May 28, 2008 at 12:21 pm

    #821380

    autoshrink is a bad idea for any database because it can lead to fragmentation

  • May 28, 2008 at 12:37 pm

    #821390

    yes, but can I autoshrink tempdb? can I do that. If yes, what is the procedure.

  • May 28, 2008 at 1:02 pm

    #821404

    No, you can't set AutoShrink in TempDB.

    "Got no time for the jibba jabba!"
    -B.A. Baracus

  • May 28, 2008 at 1:07 pm

    #821407

    ahutch (5/28/2008)

    No, you can't set AutoShrink in TempDB.

    And thank goodness for that. That would be a performance disaster. You don't want to do that IMO.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • May 28, 2008 at 1:26 pm

    #821416

    thanks a ton guyss

Viewing 10 posts - 1 through 9 (of 9 total)

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