So someone let our SQL server 2008 R2 enterprise trial expire on a web server. It was part of a plan to restart a project and move everything we had over to MySql instead. We don't need anything special other than keep the old website running for a couple months.
Is express or compact capable of running a small website?
Is it possible downgrade to express or compact and how?
How can I backup the existing databases now that we have been effectively locked out of them?
Best Answer
Violation of the EULA.
Both are capable of running a small website. Express is also capable of running medium or large websites. Personally I would go for Express if possible, Express handles concurrent access much better than Compact.
Uninstall Enterprise, install Express and migrate the database to the new instance. Compact is much harder - Microsoft has no tools for downgrading to Compact. This tool, amongst others, can help you.
You might try starting the database in single user mode, or stopping the SQL Server service and getting the
MDFandLDFfiles out of theDATAdirectory and attaching them to the Express instance.