Hi

I have 2 servers A and B.
I need to move tempdb from Server A to server B.

This both servers are indentical. They are also same network.

What will be the best solution to do?

Kindly suggest any query or scripting.

Regards

jo wrote:


Maybe I am missing something, but this doesn't make much sense to me
because tempdb usually doesn't hold data (except temporarily). Here is
a script to rollback tempdb to the original 2MB size:

sp_configure allow, 1
go
begin tran
delete master .. sysusages
where dbid = 2 and lstart != 0
go
update master .. sysusages set segmap = 7 where dbid = 2
go
select * from master .. sysusages where dbid = 2
you should see the following output, if not rollback the transaction:
dbid segmap lstart size vstart
2 7 0 1024 2564

commit tran
go
sp_configure allow, 0
shutdown
go

disk init new devices
alter tempdb onto the new devices


Tom