CrazySQL

Posts Tagged ‘tempdb

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





 

November 2009
M T W T F S S
« Jul    
 1
2345678
9101112131415
16171819202122
23242526272829
30