View Single Post
Old 29th December 2012, 06:53 PM
Adam Adam is offline
Senior Member
Join Date: Jan 2009
Member of: Redfearns & the UBC
Location: Leeds
Posts: 583

Originally Posted by RobF View Post
the backups are there, but we can't splice them into the ongoing forum easily, we either roll back and lose subsequent posts or continue with lost posts.

the key is trying to find out why the host failed in the first place... but i'm already looking at alternative hostings...
Doesn't the DB get journalled? We run a 24/7 hospital system. If it goes down, the DB server fails over to the backup server, open transactions are rolled back, and the application servers reconnect to the newly active DB server. If we lost both and had to restore last night's backup we'd replay the journal and get the DB to the state it was the instant it went down.
Reply With Quote