Viewing 4 posts - 1 through 4 (of 4 total)
Also the you must restart sql server
September 5, 2003 at 12:59 am
Yes the location is permanent, you can change size and location of the tempdb by using hint :
sqlservr -c -f
GO
ALTER DATABASE tempdb
MODIFY FILE (NAME = tempdev , size=220)
go
ALTER DATABASE...
September 5, 2003 at 12:58 am
So you can do the same think to restore your database on the new disk with the move option.
June 27, 2003 at 1:48 am
We have to move all databases to a new server last month with distribution. The best way i have found was to backup all databases and restored all db on...
June 27, 2003 at 1:45 am
Viewing 4 posts - 1 through 4 (of 4 total)