This is a good question. I tend to steer well clear of SqlCE in a production environment nowadays but do have a couple of old client sites running CE. I'm assuming it means that the databases are never correctly backed up! I'd be very interested to know if there's a back-up solution that is able to disconnect CE before running.
Another major flaw with running SQL Ce in a production environment!
placeing an app_offline.htm file in the root of your solution, will take the application off line (it displays the contents of the app_offline file) and disconnects IIS from the DB so you can rename/copy do what you need to do.
How to backup a .sdf file? (SqlCE database)
I created my first Umbraco website, and I really like the CMS.
But how can I backup all? (with a SqlCE DB used)
I have copied all files, but "Umbraco.sdf" wont copy, it is used by other users.
Possibly it has some db connections open, but how do I close them or how can I backup the DB in a other way?
Usually you need to stop your website/server (i.e IIS) to copy the SQL CE File - as it will contain the locking process.
Yes of course, but what if the website is hosted where you do not have access to IIS?
Is there any other solution?
This is a good question. I tend to steer well clear of SqlCE in a production environment nowadays but do have a couple of old client sites running CE. I'm assuming it means that the databases are never correctly backed up! I'd be very interested to know if there's a back-up solution that is able to disconnect CE before running.
Another major flaw with running SQL Ce in a production environment!
Just had a quick look,
placeing an app_offline.htm file in the root of your solution, will take the application off line (it displays the contents of the app_offline file) and disconnects IIS from the DB so you can rename/copy do what you need to do.
http://weblogs.asp.net/scottgu/archive/2005/10/06/426755.aspx
Kevin
Good find, thanks Kevin.
Tnx Kevin, that worked fine.
is working on a reply...