Copy a Database to a different instance, but keep source operational
I cant use copy DB Wizard. The RESTORE command includes the MOVE command, doesn't this MOVE command move my ldf and mdf to the new DB file location?? If the MOVE command moves my ldf and mdf, doesn't it remove functionality from my source DB. I need to copy my DB to an new instance, but i need to keep my source DB fully operational. Its the MOVE command i am worried about. thank you for your assistance.
No, your understanding of WITH MOVE is a bit to literal. If you are restoring the database to a new name or new server and specify WITH MOVE you are specifying where to place the file(s) other than the original path. For instance, if you have your data file on G:\sqldata\dbname.mdf and log on H:\sqllog\dbname.ldf and on the new server you do not have an G: and H: and want to restore the files to drive M:, you could specify WITH MOVE and specify the new path and new names. DB Wizard isn't the option you need if a simple backup/restore would work. The only time a restore would disrupt production is if you are restoring over a production database using WITH REPLACE. Does this help and make sense?