Hi Sunshine,

I'm sorry you feel that the backup section of the documentation is not up to your standards, but I for one think its one of the best. That's just my opinion.

You do not need to use the stored procedure, if you have a SQL agent, by all means use that.  The reason for the storeproc is so that people without a proper agent can dump the SQL database to a flat file. 

Please just remember that when using an SQL agent to make sure that the SQL backup happens when Enterprise Vault is in read-only mode.

You want to keep these three in sync:

• Indexes
• Vault Stores
• SQL Databases

Are you using the regkeys to place Enterprise Vault into read-only mode or are you using powershell?

--wayne

Hi Wayne,

I was planning to use the evopmode.bat file to put in read only and read/write mode.  I was also planning to use the powershell script to set the backup mode and clear the back mode for the vault store and indexes.  I am running an MS Cluster.  Do I need to do both these operations or just one?  The evopmode.bat sets the regkeys.  Thanks for your help in this matter, I'm just in the process of getting my head wrapped around the backup process for Enterprise Vault.

Thanks,
Sunshine.

Sunshine,

I always limit my scripts to one server, making management simpler in the long run, also a lot less change of scripts not syncing up.  If you are on v8 i would recommend just using powershell to place the Vault Stores into read-only mode. The regkeys will be come dormant sometime.

Also if you use powershell, you will not need to restart any services :) which is my preferred method. I hate restarting services when there is no need to......

Are you thinking of using the SQL agent or dumping the databases to a flat file?

--wayne

When you say use the powershell script to place the vault store into read-only mode, is that the below script?

Powershell.exe -psconsolefile "E:\Program Files\Enterprise Vault\evshell.psc1" set-IndexLocationBackupMode servername

Powershell.exe -psconsolefile "E:\Program Files\Enterprise Vault\evshell.psc1" set-vaultstorebackupmode -name 'Vault Store Group' -evservername servername -evobjecttype 'vaultstoregroup'
 
I am using EV version 8 SP1.  I'm wanting to use the SQL agent to backup the database.

Here is what I'm thinking I need to do if the above powershell script is the correct way to put the server in read only mode (I'm using MS Cluster)

1.  Pre-Backup; Set the backup mode for Index and the Vault Store Group
2.  Start the complete system and file backup
3.  Have the SQL agent backup the databases at the same time as the system and file backup
4. Post-Backup; Clear the backup mode with the powershel script below
     Powershell.exe -psconsolefile "E:\Program Files\Enterprise Vault\evshell.psc1" clear-IndexLocationBackupMode servername
     Powershell.exe -psconsolefile "E:\Program Files\Enterprise Vault\evshell.psc1" clear-vaultstorebackupmode -name 'Vault Store Group' -    evservername servername -evobjecttype 'vaultstoregroup'

Another Question:
Does this need to be a full backup everytime or will I be able to use incrementals?  Also if I'm going to use the poweshell script do I need to clear out the registry keys that were added by the evopmode.bat file? 

Thank,
Sunshine

Thanks Wayne,

You've been a big help in getting my backup plan rolling forward.  Thanks again for all your help.

Thanks,
Sunshine Baines

Sunshine,

If you have your solution then please mark the solution post.

It keeps things tidy in here, so many never mark solutions and it makes it easier for others to find solutions

I for one think the backup procedure for the Vaults and Indexing are awesome. However, I too think that the SQL backup portion is poor and ill-defined.
For those of us who aren't SQL gurus, how does one call a stored procedure from a powershell script?
How does all of this play into the use of the Backup Exec agent for Enterprise Vault? I'm told that 8.0 isn't support for the agent which makes sense but shows extremely poor communication within Symantec (don't tout an agent for one product that doesn't work with the latest release of another product).

I would like recommendations on backups of Enterprise Vault 8 data on SAN.  The SQL database backups should be straightforward, but not sure about the vauld data on the SAN disks.  What is the best way to backup the data (not SQL)?  How often?

Thanks

HKP11, Please start a new thread as this one has been marked solved.

Would the same apply for 7.5 SP2?