backup and restore options incase system crached

Question

Hi,

I have 1 DB Server and 1 SharePoint Server (APP + WFE). I have 1 Full Farm Backup and 1 Differential Backup. Please guide me steps to follow in-case of server failure under following senario.

Scenario 1: SharePoint Server (APP + WFE)  Crashed , Database server intact
What step i have to follow in order to restore my SharePoint. 

Scenario 2 : Database server crashed , SharePoint Server (APP + WFE) intact
What step i have to follow in order to restore my Sharepoint. 

Please also give recommendation.

Thanks

---

iffi

Answer 1

The best answers:

• Plan for disaster recovery (SharePoint Server 2010): http://technet.microsoft.com/en-us/library/ff628971.aspx
• Simplifying SharePoint Backup and Recovery: http://www.meritalk.com/uploads_legacy/whitepapers/Sharepoint(1).pdf
• http://www.avepoint.com/assets/pdf/sharepoint_whitepapers/Best-Practices-for-SharePoint-Backup-and-Recovery.pdf

Hope helps.

---

http://valygreavu.wordpress.com/

Answer 2

Hi,

Thanks for link.  Please share life experience. if possible.

thx.

---

iffi

Answer 3

After the farm is ready I made a regular farm backup and after that a full database backup. Also I'm doing a full system state backup of all servers implied into the architecture.

Another point is to backup IIS from all App servers.

I made Regular backups only for SQL Server databases.

If something is going wrong with APP servers: first step is to recover OS, configure all software and restore FARM backup (initial one). After that I'm restoring SQL Databases.

If something's wrong with DB server: recover OS, configure software and restore last full beackup of SQL Server databases and after that one by one last incremental backups.

Of course all backups files are stored into a separate store device.

A specific Romanian Joke for backup operators: You must believe in God and whole infrastructure is protected! :) 

---

http://valygreavu.wordpress.com/

Answer 4

Hi,

what if i just take database full and incremental backup, 14 hive folder backup and not to take any further backup.

in case to disaster should i able to restore farm by just having database backup. what steps i have to follow in order to restore farm.

thanks,

---

iffi

Answer 5

Plan for disaster recovery (SharePoint Server 2010): http://technet.microsoft.com/en-us/library/ff628971.aspx

---

http://valygreavu.com/

Answer 6

There are consultants for these topics as experience comes with try/error moments.

Anyway,

Scenario 1 : You re-install APP and WFE. Better use same server name, and remove all SharePoint databases that are on the SQL. When you re-install the APP and WFE this will create the default databases (SharePoint Config and few others). When you are done, just restore the databases you had from the previous installation. Create the Web Applications/Site Collections that you have had and do a restore (if it is necessary). You must use same accounts, so keep this in mind.

Scenario 2 : Re-install the new SQL but use the same server name if possible. Just Add the databases and you are ready to go. WFE and APP will find the databases automagically.

One more thing is that all customizations that are not in the database (webparts, solutions etc) you must re-apply them again, or put the files respectively in the 14 hive folder.

I suggest you try this in a lab, and see how it works.

Cheers,