Click here to Skip to main content
14,970,304 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I want to take backup of the database from the debug of the running folder but i get the error that
"The process cannot access the file because it is being used by another process."
the file is database file .
please reply me fast.

1 solution

The database files are locked by the MS SQL Server. In order to backup these files and avoid data corruption, it is necessary to perform these actions:
1) Stop the MS SQL Server.
2) Perform the backup.
3) Restart the MS SQL Server.

Have a look on these links (you may get good knowledge on backup process)
1) How to: Back Up a Database (SQL Server Management Studio)[^]
2) Backup MS SQL Server data[^]
3) Backup Overview (SQL Server)[^]
astika 20-Dec-10 23:51pm
I actually have to do all this in's code.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900