January 7, 2013 at 7:16 am
In order to avoid any failure please add some space to tempDB database on xyz server. I am a new DBA, how to do step by step, please help!
I can't shrink the tempdb, either.
January 7, 2013 at 7:57 am
If you have more than one tempdb data file, be CERTAIN to size them the exact same size and make sure you do not have autogrowth set to ON, size them accordingly!
In Management Studio (or by right-clicking on the tempdb database in the GUI)
USE [master]
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdb', SIZE = 84592640KB )
GO
The value in KB above is a value you will need to change based upon your preference and available space on the drive where your tempdb resides. Do not max out the drive space on the drive containing your tempdb
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
January 7, 2013 at 7:23 pm
ThanQ! This helps a great deal.
January 8, 2013 at 1:42 am
If you have more than one file restart the instance afterwards to kickstart the proportional fill from equal file sizes.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply