Re: SQL下如何转移tempdb# Software - 软件世界
h*l
1 楼
In SQL Server 7, tempdb is the only database that you can
move using the
ALTER DATABASE command:
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'tempdev', Filename = 'newpath/tempdb.mdf)
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'templog', Filename = 'newpath/templog.ldf)
The changes will not take effect until the SQL Server is
restarted.
move using the
ALTER DATABASE command:
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'tempdev', Filename = 'newpath/tempdb.mdf)
ALTER DATABASE tempdb
MODIFY FILE (
Name = 'templog', Filename = 'newpath/templog.ldf)
The changes will not take effect until the SQL Server is
restarted.