January 15, 2012 at 10:30 am
Hi guys!!!
It's me again, well probably this is a basic question but i just want to confirm it.
I need to reduce the size of my tempdb (temporarily ), that's possible just restarting the instance? or just stop and restart the sql service?
I have a down time to do that, but what's the risk to do that? thanks
Regards.
January 15, 2012 at 10:44 am
Do you mean you want to reduce it back to it's 'starting' size? Or do you want to reduce it's starting size?
A restart of the SQL Instance will reset it back to it's starting size.
If you want to reduce the starting size, alter it before the restart. MS's KB article on it is here - http://support.microsoft.com/kb/307487
If you're just restarting SQL then it's very low risk, assuming you've nothing strange set up. Just make sure you restart the right instance, and if you do it by restarting the SQL Server service remember that each instance has it's one SQL Server Service. Getting the wrong one isn't a good idea :w00t:
Training cats makes SQL Server look easy
January 15, 2012 at 11:14 am
stuart@leaf-node (1/15/2012)
Do you mean you want to reduce it back to it's 'starting' size? Or do you want to reduce it's starting size?A restart of the SQL Instance will reset it back to it's starting size.
If you want to reduce the starting size, alter it before the restart. MS's KB article on it is here - http://support.microsoft.com/kb/307487
If you're just restarting SQL then it's very low risk, assuming you've nothing strange set up. Just make sure you restart the right instance, and if you do it by restarting the SQL Server service remember that each instance has it's one SQL Server Service. Getting the wrong one isn't a good idea :w00t:
Ah i see, i just want to reset it back to it's starting size, however l'm gonna take a look into the kb (thanks).
Yes there's only one instance, thanks for the tip stuart 😉
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply