Increasing tempdb size in a SQL Server Cluster (after ALTER DATABASE execution)

December 19, 2008


Today one of my colleagues came across to me fo the problem, he wants to increase the “Tempdb” file size in SQL Server 2005.

we had tried from SQL Server GUI but we are getting teh error mesaage,

“microsoft sql server error 5039”

we followed the following steps, hope it will be helpful to you also.

Step 1  :- Go to the start –> All Programs  –>  Microsoft SQL Server 2005 –>Configuration Tools –> Notification Services Command Prompt.

Step 2 :- now follows the following steps in the command Prompt(Notification Services Command Prompt).

Step3 :-

C:\>sqlcmd -S SQL-2005\YUKON
1> USE master
2> GO
Changed database context to ‘master’.
1> ALTER DATABASE tempdb
2> MODIFY FILE ( NAME = tempdev, SIZE = 70MB )
3> GO
1> exit

Enjoyeeee,

Regards,

Kuntal Patel (Sr. System Administrator)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: