I have set up a set of SQL databases. I need to be able\nto copy the files for backup as well as to copy the\ncurrent data to the web directory.\n\nI assume the files I need to copy for the SQL databases\nare the mdf and ldf files. Am I on the right track copying\nthese file types?\n\nIt appears that in order to move these files, I need to\nstop the SQL Server during the file copy. It then needs\nto be restarted after the process is complete. Can I do\nthis in my batch file? What are the commands?\n\nAfter these files are copied and the SQL Server service\nrestarts, will the SQL Server be able to use these new\nfiles?