Shawn Melton (4/22/2011)
The detach\attach method is the best method if you just need to move it for one database.
Disagree...
You can move a database file using ALTER DATABASE, then take just that database offline, move the file, then bring the DB back online. Better solution if there's CDC, replication or other such things configured.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability