How would you handle moving a big database(say 200GB) to another drive with minimal time on a production server??
An option, should the SQL Server Versions be the same, is to mirror the database across to the new Server and once it is running as it should be, copy the users, Jobs, maintenance plans etc; across to the mirror from the principal. Once prepared, perform a switchover to the new machine and the move is complete with the very Minimum of downtime, measured in seconds. Users will be disconnected for the period of the switchover but that is easily planned for.
Of course, in order to do this you Need to be using the Enterprise Version of the Software.....