Perry Whittle (12/5/2012)
Stopping sql server is a bit like using a sledge hammer to crack a nut. You only need to take the database offline as follows
ALTER DATABASE mydb SET OFFLINE
- Once offline, copy the disk files to the new locations.
- Bring the database online.
- When the database comes online successfully delete the old files.
It looks a step missing in above.
Before take offline, should there be a step that change the logical file to another directory?
I know how to do in SQL for this step, is there a way to do it in ssms?
Thanks