Originally Posted by RobF
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.