[转载] Re: SQL下如何转移tempdb# Database - 数据库
h*l
1 楼
【 以下文字转载自 Software 讨论区,原文如下 】
发信人: hanibal (ganggang), 信区: Software
标 题: Re: SQL下如何转移tempdb
发信站: The unknown SPACE (Tue May 2 17:31:56 2000) WWW-POST
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.
发信人: hanibal (ganggang), 信区: Software
标 题: Re: SQL下如何转移tempdb
发信站: The unknown SPACE (Tue May 2 17:31:56 2000) WWW-POST
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.