Restore Enterprise Vault Databases when EV Database server crashed

Last week our MS SQL Database  Server had severe hardware issues and it was down and can’t boot.  The Enterprise vault 9.0 databases are contains in this server. So none of the users cannot open archived emails because there is no database connectivity with EV.

We are regularly taking backup of these databases by using  Symantec Netbackup 7.0 version. So we need to do a restore from Netbackup server to another SQL server. In a nutshell EV disaster recover y has to perform. Yes we have done this activity successfully and i would like to share that experience with you all.

Environment

Enterprise vault server 9.0 – Installed on Windows 2008 R2 server

MS SQL 2008 R2

Symantec Net backup 7.0

 Activities performed

Prepared new server for MS SQL Database with same name and Ip addres

1. Installed Windows 2008 Server Ent R2 OS in server
2. Installed SQL 2008 Server Enterprise R2 Edition
3. Installed Office 2007
4. Installed EV client
5. Mount disks from Netapp ( Space taken from Netapp storage)
6. Patched and installed all the basic software’s and Antivirus
7. Installed NetBackup agent
8. Given the Evadmin (EV service account)  local admin and SQL sys admin permission
9. IIS and .net installed
10. Name, IP and versions are same as the old server

Now the Database server is ready for restore. Below screenshot  is taken from Netbackup server. I will list which order we have to restore all the database.

Stop the EV services from EV server before start restoring

1. Restore from Netbackup server –>Backup archive GUI–> Select the EV server
2. First restore –> Directory DB
3. Then —>Audit DB
4. Then–> Monitoring DB
5. Evsite–> EV Vault store Group–>EV Vault store DB Mangers ( we have managers vault store)
6. Evsite –> EV Vault store Group–> EV Vault store DB users ( we have users vault store)
7. Manager Partition (Evsite–>EV vault storage group–>V Vault store–>All Partition–>Open partitio
8. User Partition (Evsite–>EV vault storage group–>EV Vault store–>All Partition–>Open partition
9. Reinstall EV application ( to sync /update EV binaries) –>RunEVsetup.exe. It wont affect y0ur EV server

Now users can able to open the archived emails.

Advertisement