I have a similar issue when I need to take down a site from a live server that uses the SQL CE database. What normally do is to stop the IIS and then download all the files, and then you can start the IIS again.
Perhaps you can try the same approach by stop your application pool and the check out the SQL CE database file called Umbraco.sdf.
Unfortunately there is no solution to this - It's been like that forever. When Umbraco used another embedded database in the happy days of v4.0.x it was the same thing unfortunately.
Indeed, this is not an Umbraco specific issue. When you start the site, a small server is running to be able to use the database. This server HAS to keep the database file in use to make sure data does not get corrupted. Similarly, if you were using sqlserver, the MDF and ldf files will be in use until you stop the server and you wouldn't expect to put them in source control without having to stop the server either.
Cannot access the file 'Umbraco.sdf' because it is being used by another process.
Hello,
I'm running into this error message when loading up Visual Studio and also trying to do a check in.
"The process cannot access the file '...\Umbraco.sdf' because it is being used by another process."
Here is my setup:
1)I create a new ASP.net Empty project,
2) Using NuGet, get the latest version of Umbraco
3) Check in the Umbraco source code in TFS Source Control (The Umbraco.sdf file is checked out)
4) I set my Umbraco website to run under IIS
and thats it, nothing really special at all. However, it seems like, IIS is not releasing the lock on the "Umbraco.sdf" file.
Has anyone running into this issue?
Thanks,
Ryan
Hi Ryan,
I have a similar issue when I need to take down a site from a live server that uses the SQL CE database. What normally do is to stop the IIS and then download all the files, and then you can start the IIS again.
Perhaps you can try the same approach by stop your application pool and the check out the SQL CE database file called Umbraco.sdf.
Hope this helps,
/Dennis
Hey Dennis,
Thats what I have been doing, every single time I do a check-in or open visual studio, I have to recycle my app pool.
I was hoping if there is a concrete solution.
Thanks
Ryan
Hi Ryan
Unfortunately there is no solution to this - It's been like that forever. When Umbraco used another embedded database in the happy days of v4.0.x it was the same thing unfortunately.
/Jan
Hey Jan,
I guess its really unfortunate that there isn't a fix for this yet.
Thanks
Ryan
Hi Ryan
Don't know if it's something that is fixable - But since I don't think it's a specific Umbraco issue so HQ won't be able to fix it.
/Jan
Indeed, this is not an Umbraco specific issue. When you start the site, a small server is running to be able to use the database. This server HAS to keep the database file in use to make sure data does not get corrupted. Similarly, if you were using sqlserver, the MDF and ldf files will be in use until you stop the server and you wouldn't expect to put them in source control without having to stop the server either.
is working on a reply...