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.
Posted

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)[^]
   
Comments
astika 20-Dec-10 23:51pm
   
I actually have to do all this in c#.net'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