Enterprise Vault Backup

[velfir]

Hello there,

I quiet newbee on EV, but trying to improve my knowledge on this product. I'm working on my first install which is almost done, but I have to set a correct backup to avoid a DR loss for the whole architecture :

The data stored on my EV server

The data stored on my SQL server

I searched for a process on symantec's website to achieve the complete task but can't find a full walkthrough. I started on SQL with this one:

http://www.symantec.com/business/support/index?page=content&id=TECH87494

Which is for EV 8, and I'm working with EV 9.0.2, so is this technote ok for the 9.0.2 version of EV ? How to backup msdb and master database in the same job ?

I followed the trainning on EV, so I have the scripts to backup datas stored on my EV server, but the last question is how can I handle the two backup at the same time. I've read that they ahve to be at the same time to avoid uncoherent state between the differents componant. Is there a way to script from SQL the change status for the vault store partitions and indexes ? And launch from one point the complete backup of the system.

Thanks for your answers and idea...

E.

[RahulG · Accepted solution]

When you perform the backup of Ev you need to place your Ev in backup mode. Once the Ev in backup mode there you need to backup the Vault store , indexes and the database mainly (You can back them up one by one but you need to make sure the backup mode is enable i.e there is not new archivng happening at the same time .) Once everything is backed up you need to clear the backup Mode .

refer the following document http://www.symantec.com/business/support/index?page=content&id=TECH64458

Have a look on the Related documents as well .

Backup of MSDB and Master database is not important with respect to backing up Enterprise vault

[AndrewB]

this article is useful as well. http://www.symantec.com/docs/TECH74666

[velfir]

Thanks for your help, but the real challenge is to launch the sql backup during the time that EV is in backup mode.

By script I know how to put EV in backup mode, after the backup mode i know how to launche the DB backup with your help now, the last question is, once everything is backedup, how can I put EV in normal mode automatically ?

Thanks...

[Liam_Finn1]

If you want to call a command from SQL to put the EV back into normal mode you need to first create a .CMD file that calls the powershell script for EV to put it back to normal mode

Next you need to create a stored procedure in SQL to call the .cmd file Then in your maintenance job to backup your SQL databases you call the stored procedure

The process is SQL maintenance plan kicks off to backup the SQL databases

The last part of the SQL maintenance plan calls the stored procedure which launches the .cmd file and runs the powershell script to set the mode for EV to normal

For this to work you need powershell on your SQL server as well as all your EV servers