IT Infrastructure blog

November 30, 2011

Restore Enterprise Vault Databases when EV Database server crashed

Filed under: Enterprise Vault 8.0,Symantec Netbackup — Akther @ 7:23 pm
Tags:

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.

Advertisements

1 Comment »

  1. Hi Akther,

    Thank you for sharing this experience. Backup is appreciated when we need it. It is so nice to see that NetBackup came to the rescue when you lost the SQL Server hosting Enterprise Vault. Congratulations on saving the day for the users!

    Warm regards,

    Rasheed

    Comment by Abdul Rasheed — December 13, 2011 @ 9:09 pm | Reply


RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Blog at WordPress.com.

%d bloggers like this: