how to copy database files from the network access server to Client PC in .net?

Question

im using a code to copy the files from the database of server PC. so im accessing that server PC through IP address but it is giving me error and not copying the files in the folder of my PC (client PC) this is my code that im using...can u tell me where im wrong??

the file path is given on my listview in winform..

public string RecordingFileCopy(string recordpath,string ipadd)
{
    string strFinalPath;
    strFinalPath = String.Format("\\{0}'{1}'",ipadd,recordpath);
    return strFinalPath;
}

on button click event....

   {
        try
        {

            foreach (ListViewItem item in listView1.Items)
            {
                string sourceFile = item.SubItems[5].Text;
                RecordingFileCopy(sourceFile,"10.0.4.123");  
                File.Copy(sourceFile, Path.Combine(@"E:\name\MyDir", Path.GetFileName(sourceFile)));
            }

        }
        catch
        {
            MessageBox.Show("Files are not copied to folder", _strMsg, MessageBoxButtons.OK, MessageBoxIcon.Error);
        }
    }

Answer 1

If your database is is currently attached to the database server, e.g. SQL Server is attached to the .mdf file you want to copy, then file is locked and you won't be able to copy it. You'll first need to detach from the target database.