1. Find out the location of Tempdb Data and Log file.

1

  1. We cannot move the tempdb by detach and attach method or backup and restore method.

We can move the Tempdb by Alter Database method.

 

2

  1. Restart SQL Server Service. Using SQL Server Configuration manager.

3

  1. Now time to verify the new location of tempdb files.

4

  1. Delete the Old tempdb files.
Moving Tempdb database data and log files

Leave a Reply