sql 2008 express into cluster

Is it possible to connect two sql server 2008 express into cluster?

Why we want cluster? We have SQL express DB for our software but what if DB crash or something. So we want to have backup in second server and if primary go down backup start running. Which solution is best?

Thx

Answers


To summarise, if you have Express edition you have no High Availability options including mirroring, clustering, replication, anything.

You get what you pay for. Either your data is valuable and you pony up for Enterprise CPU licenses (it's a web app) or you reinstall/restore when the shit hits the fan...


No. From the feature list for editions only standard or enterprise edition support clustering.

(Under the High Availability Section)


You can't set up clustering or mirroring, but you can set up a poor man's "log shipping." Whatever you're using to generate the backups of your database (Task Scheduler or some other scheduling system) could be used to copy the backup to another install of SQL Server Express and then use SQLCMD to apply the backup.

Also, keep in mind that in a clustering situation, there is still but one copy of the database. Microsoft clustering with SQL Server is a shared nothing configuration. That means the disk belongs to only one physical server at a time and the databases reside on that physical server. The reason that's important is to think about why the DB crashed. If it crashed due to corruption or the physical disk failure, you'd still be down in a clustering situation. Now, if the physical server crashed, then in a clustering situation you'd failover, meaning you'd have a 30 second to a few minute downtime.


Need Your Help

LibGDX Texture to ByteBuffer

textures libgdx bytebuffer pixmap

I am trying to convert a Texture to a Pixmap in LibGDX so I can get all of the pixel data into a ByteBuffer for some experiments, and from what I can tell, I should be able to do this by doing the

How to web scrape AJAX Update Panel with c#?

c# asp.net ajax web-scraping updatepanel

I am looking to web scrape a site that has an AJAX update panel. I have been able to login to the website using properly constructed HTTP requests (HttpWebRequest) and I am able to send a POST requ...