Hello all!
I'm trying to create an application which makes a copy of the database file it is using on application start and can restore it at any time, if needed (little project about SQL injection, so I need the copy ;-) ). This works fine, but as soon as I make my first connection to the db (connection_object.open()) and close it again I can not access the file anymore, because it is "in use by another process". How can I release all handles from the database, so that I can replace the DB file with it's backup copy
Thank you
Kolja
How to close all open "handles" to a SQL Server 2005 express DB?
Hot Topic
- Warehousing Data From Multiple Companies: What do I need to learn about?
- How to add a second table in Report Builder?
- SSIS The product level is insufficient for component "Fuzzy Grouping"
- Import/Export data with SQL Server 2005 Express
- SSIS and COM
- Execution of queries on tables without table owner specified fails.
- Create 1 connection to execute multiple Packages
- SQL Server 2005 Service Pack 1
- SQL 2005 Express June CTP
- FTP task
SQL Server
- ODBC Data Source error
- Error on Reporting Server - but only through the ReportViewer control
- Using Service Broker for reliably transmitting events to consuming applications
- Get list of all Databases in an SQL server
- OLEDB provider error.
- Modifing XML document is too slow
- Not able to view the Drill down section in the Report Manager
- For security reasons DTD is prohibited in this XML document
- Variables in CONTAINSTABLE. IS IT POSSIBLE? NO ERRORS AND NO RESULTS.
- What is this?
How to close all open "handles" to a SQL Server 2005 express DB?
copier_guy
cal me a noob, but I disposed it and set the variable to null... doesn't work
What do you mean : Call GC
Balu Vasudev
Shot two bulets in his head and call GC to finish him.