Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Moving Database Files Detach/Attach or ALTER DATABASE? RE: Moving Database Files Detach/Attach or ALTER DATABASE?

  • May 27, 2009 at 4:59 am

    #1000471

    Hi All,

    One more thing to add to this is that if you want to move TEMPDB database to different location, Alter DAtabase is only option you have.

    You need to restart SQL Server services in order for it to affect.