moving tempdb Microsoft SQl server 2000 2005
- Angelo Schalley
- Dec, 01, 2009
- MS SQL
- No Comments
check to see what the setting is right now :
USE tempdb
GO
EXEC sp_helpfile
GO
after checking, change the location acording
USE master
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev, FILENAME = ‘D:\tempdb.mdf’)
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = templog, FILENAME = ‘D:\templog.ldf’)
GO
Categories
