sqlserver 2005 tempdb 转移到别的位置

1.stop sqlserver

2.copy tempdb files(mdf/ldf) to new folder

3.restart sqlserver

4.exe sql:

   USE master;
GO
ALTER DATABASE tempdb
MODIFY
FILE (NAME = tempdev, FILENAME = 'E:\tempdb\tempdb.mdf');
GO
ALTER DATABASE   tempdb
MODIFY
FILE (NAME = templog, FILENAME = 'E:\tempdb\templog.ldf');
GO

5.stop sqlserver

6.delete old files

7.restart sqlserver

posted on 2009-02-06 11:16  Joe Hou  阅读(636)  评论(0编辑  收藏  举报