• 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.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉