• Ratheesh.K.Nair (1/17/2013)


    The thing is we need to stop the services for moving files right?

    No no no, again wait for my article. This is the biggest misconception. You DO NOT have to stop the SQL Server services to move the user database files, Offlining the database will allow you to move the files without SQL Server locking them.

    Only the system dbs (master, etc) will require the service offline

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

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