opc.three (4/9/2012)
however what if you had multiple files to move and missed one?
The database would not come online!
The only time this would differ in any way is with file group restores but that's a whole different scenario and not even relevant to this post\script.
I always issue my move commands before offlining the database that's the preferred\tested method for me.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉