Hypothetical Disaster Recovery question

We have on-premise set up with two servers: (1) Application/Document Server and (2) Database Server.

In a hypothetical scenario: We lose Server #1 and have to rebuild and restore from a backup, but the next good backup is a week old. My question would be, what would I need to be concerned with or do to resynch my #1 - Application/Document server (week old data) with my #2 - Database Server (current data)?

Thank you!

Parents
  • First of all: you should rethink your backup strategy before this scenario changes from hypothetical to real world! 

    I understand your set up this way: Files and configurations are stored on server #1, and database is stored on server #2.
    Your database contains links to files stored on #1. The links created within the last week will not be valid if you rebuild #1 from a week old backup. You would have to rebuild the database from a backup created at the same time as the backup of #1. Before you do that I would try to get a list of objects in the database created since that backup.Not sure if it can be done or how to go about it, but if possible that would be helpful when you try to recreate those objects after rebuilding the servers from your old backup.

    If you decide to only rebuild #1 and keep the current database on #2 you might be able to fix some of the issues in the database using the repair tools. I am not sure exactly how the tools will handle the issues with missing documents or whether they can handle them at all. But no matter what those files will be lost and need to be recreated manually somehow if they are valuable enough to justify the effort.

Reply Children
No Data