~ Tiez Notes ~

use tmpdb
backup log tempdb with no_log
dbcc shrinkfile (2,1)
dbcc shrinkfile (1,1)

use master
go
Alter database tempdb modify file (name = tempdev, filename = ‘E:\Sqldata\tempdb.mdf’)
go
Alter database tempdb modify file (name = templog, filename = ‘E:\Sqldata\templog.ldf’)
Go

RESTORE FILELISTONLY FROM DISK = ‘E:\DB\PF31Des2007.bak’
RESTORE DATABASE PF31Des2007
FROM DISK = ‘E:\DB\PF31Des2007.bak’ WITHREPLACE,
STATS = 10,
MOVE ‘CSF_Data’  TO ‘E:\Database\PF31Des2007_Data.mdf’,
MOVE ‘CSF_Index’ TO ‘E:\Database\PF31Des2007_1.mdf’,
MOVE ‘CSF_Log’   TO ‘E:\Database\PF31Des2007_log.ldf’
GO
RESTORE DATABASE PF31Des2007 RECOVERY

GO