HI all 1.hi guys how to put the tempdb on its seperate drive as the database is already created.how to change the path. Thanks in advance.
Check out the explanations to ALTER DATABASE in BOL. Under example G: you will find how to move tempdb to a new location.
Try this sample!! use master go Alter database tempdb modify file (name = tempdev, filename = 'E:Sqldata empdb.mdf') go Alter database tempdb modify file (name = templog, filename = 'E:Sqldata emplog.ldf') Go
