sqlfriends (12/10/2012)
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
Yes, you need to use the ALTER DATABASE ... MODIFY FILE command but in your first post you've already done that!!!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉