CrazySQL

Archive for July 2008

Moving tempdb to new location in SQL server 2005

Posted by: Manpreet Singh on: July 2, 2008

As a sql server administrator, many time i have seen “tempdb out of space” problem. the best solution to solve this problem is to move the temp db to new location so that it has enough space to expand
given below is the procedure to move tempdb database to newer location
1. Open SQL Server Management Studio.
2. [...]

Tags:

View Manpreet Singh's profile on LinkedIn





 

July 2008
M T W T F S S
    Aug »
 123456
78910111213
14151617181920
21222324252627
28293031