May 27, 2008 at 8:15 am
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
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
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
why do you want to backup tempdb?
May 28, 2008 at 12:18 pm
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
autoshrink is a bad idea for any database because it can lead to fragmentation
May 28, 2008 at 12:37 pm
yes, but can I autoshrink tempdb? can I do that. If yes, what is the procedure.
May 28, 2008 at 1:02 pm
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
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
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