Browse by Tags

All Tags » database » tempdb » detach
  • Move tempdb and don't want to use Detach method!

    A new Developer within our testing environment asked me this question to see whether they can use DETACH/ATTACH method than using ALTER database method. For the user databases it is available such method of DETACH/ATTACH method when moving the databases, but for system database it is not possible as they are in exclusive use for sqlserve.exe file. ...
    Posted to SQL Server Aggregator (Weblog) by Anonymous on August 27, 2007