I have an problem while copying database file to another folder.
In Brief i have develop an windows application in that one form is Data Backup and restore. Suppose i have run form separately then i will copy these file from one place to another but if i have loged in then use this form then it give me an error that File used by another process. I have try to close the sqlconnection and the current connectionstate is closed still i have an error.

i am using sqlexpress as sqlserver database.

Can anybody help me....

7 Years
Discussion Span
Last Post by bhagawatshinde

If you open a connection to the database, .NET actually opens multiple connections to that database (the connection pool). This is done to speed up future connections (in your program) that you might need. Even if you close all your connections, .NET maintains its open connections in case you might want to connect again.

You'll have to ensure that your software *never* connects to the database if you want to do a file copy.


Hi, Momerath
I am Trying to kill the 'sqlservr' process by using this code but still i have found an error access denied ,

Process[] Pro = Process.GetProcessesByName("sqlservr");
                    foreach (Process proce in Pro)

would anybody help me....is thier is any another way to copy files.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.