Document ID: 322715
http://support.veritas.com/docs/322715
E-Mail this document to a colleague
http://support.veritas.com/docs/322715
E-Mail this document to a colleague
How to Backup Enterprise Vault (EV) 8.0 SQL Databases
Details:
The following instructions are for Enterprise Vault
environments where there is not a 3rd party backup software that will utilize a
'SQL Agent' to perform a logical backup of the SQL Databases. This process
will allow SQL backups, or dumps, to occur of the databases outside of any other
backup schedules
For addition assistance in configuring backups in SQL, please see the SQL Administration documentation regarding proper maintenance.
Configuring Enterprise Vault Database Backup Stored Procedures and Views
For Microsoft SQL Server 2005/2008:
1. Download and extract SQL scripts from tech note 320845 (referenced within the 'related documents' section below)
2. Open SQL Management Studio
3. Choose New Query
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the contents of the view_VaultStoreBackup.sql into the query window and choose Execute.
This will create the view 'dbo.view_VaultStoreBackup'. The VaultStoreBackup view will query the EnterpriseVaultDirectory database for the SQL Server location and database name for the EV Vault Store, Vault Store Group, Monitoring, and FSA databases.
6. Delete the contents of the query window
7. Copy and paste the contents of the aspa_BackupEVDatabases.sql into the query window and choose Execute.
This will create the stored procedure 'aspa_BackupEVDatabases'. The aspa_BackupEVDatabases stored procedure will backup the EnterpriseVaultDirectory database, databases listed in the VaultStoreBackup view, and truncate the associated database transaction log.
For Microsoft SQL Server 2000:
1. Download and extract SQL scripts from technote 320845 (referenced within the 'related documents' section below)
2. Open Enterprise Manager
3. Choose Tools | SQL Query Analyzer
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the contents of the view_VaultStoreBackup.sql into the query window and choose Execute (green arrow button).
This will create the view 'dbo.view_VaultStoreBackup'. The VaultStoreBackup view will query the EnterpriseVaultDirectory database for the SQL Server location and database name for the EV Vault Store databases.
6. Delete the contents of the query window
7. Copy and paste the contents of the aspa_BackupEVDatabases.sql into the query window and choose Execute (green arrow button).
This will create the stored procedure 'aspa_BackupEVDatabases' The aspa_BackupEVDatabases stored procedure will backup the EnterpriseVaultDirectory database, databases listed in the VaultStoreBackup view, and truncate the associated database transaction log.
Manually Performing Backups of Enterprise Vault SQL Databases Using Configured Stored Procedures
For Microsoft SQL Server 2005/2008:
1. Create a backup location for the Enterprise Vault databases
2. Open SQL Management Studio
3. Choose New Query
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the following query into the Query window, using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
For addition assistance in configuring backups in SQL, please see the SQL Administration documentation regarding proper maintenance.
Configuring Enterprise Vault Database Backup Stored Procedures and Views
For Microsoft SQL Server 2005/2008:
1. Download and extract SQL scripts from tech note 320845 (referenced within the 'related documents' section below)
2. Open SQL Management Studio
3. Choose New Query
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the contents of the view_VaultStoreBackup.sql into the query window and choose Execute.
This will create the view 'dbo.view_VaultStoreBackup'. The VaultStoreBackup view will query the EnterpriseVaultDirectory database for the SQL Server location and database name for the EV Vault Store, Vault Store Group, Monitoring, and FSA databases.
6. Delete the contents of the query window
7. Copy and paste the contents of the aspa_BackupEVDatabases.sql into the query window and choose Execute.
This will create the stored procedure 'aspa_BackupEVDatabases'. The aspa_BackupEVDatabases stored procedure will backup the EnterpriseVaultDirectory database, databases listed in the VaultStoreBackup view, and truncate the associated database transaction log.
For Microsoft SQL Server 2000:
1. Download and extract SQL scripts from technote 320845 (referenced within the 'related documents' section below)
2. Open Enterprise Manager
3. Choose Tools | SQL Query Analyzer
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the contents of the view_VaultStoreBackup.sql into the query window and choose Execute (green arrow button).
This will create the view 'dbo.view_VaultStoreBackup'. The VaultStoreBackup view will query the EnterpriseVaultDirectory database for the SQL Server location and database name for the EV Vault Store databases.
6. Delete the contents of the query window
7. Copy and paste the contents of the aspa_BackupEVDatabases.sql into the query window and choose Execute (green arrow button).
This will create the stored procedure 'aspa_BackupEVDatabases' The aspa_BackupEVDatabases stored procedure will backup the EnterpriseVaultDirectory database, databases listed in the VaultStoreBackup view, and truncate the associated database transaction log.
Manually Performing Backups of Enterprise Vault SQL Databases Using Configured Stored Procedures
For Microsoft SQL Server 2005/2008:
1. Create a backup location for the Enterprise Vault databases
2. Open SQL Management Studio
3. Choose New Query
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the following query into the Query window, using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVDirectoryDatabaseSQLServer'
,
@BackupFolder='BackupLocation'
,
@DirectoryUser='Enterprise
Vault Service Account',
@Credential='Enterprise
Vault Service Account Password'
Example:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVSQL'
,
@BackupFolder='C:\Backups\'
,
@DirectoryUser='EVDomain\VaultAdmin',
@Credential='Password'
6. Click Execute
7. Backups will be created in the backup location specified in Step 1.
8. For each database, a separate backup file (*.BAK) file will be created.
For Microsoft SQL Server 2000:
1. Create a backup location for the Enterprise Vault databases
2. Open Enterprise Manager
3. Choose Tools | SQL Query Analyzer
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the following query into the Query window, using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
7. Backups will be created in the backup location specified in Step 1.
8. For each database, a separate backup file (*.BAK) file will be created.
For Microsoft SQL Server 2000:
1. Create a backup location for the Enterprise Vault databases
2. Open Enterprise Manager
3. Choose Tools | SQL Query Analyzer
4. From the list of Databases choose EnterpriseVaultDirectory
5. Copy and paste the following query into the Query window, using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVDirectoryDatabaseSQLServer'
,
@BackupFolder='BackupLocation'
,
@DirectoryUser='Enterprise
Vault Service Account',
@Credential='Enterprise
Vault Service Account Password'
Example:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVSQL'
,
@BackupFolder='C:\Backups\'
,
@DirectoryUser='EVDomain\VaultAdmin',
@Credential='Password'
6. Click Execute (green arrow
button).
7. Backups will be created in the backup location specified in Step 1.
8. For each database, a separate backup file (*.BAK) file will be created.
Automatically Performing Backups of Enterprise Vault SQL Databases Using Configured Stored Procedures
Note:
This process assumes that the SQL Server Agent is started and operational
For Microsoft SQL Server 2005/2008:
1. Create a backup location for the Enterprise Vault databases (ex. C:\Backups)
2. Open the SQL Management Studio utility
3. Browse to SQL Server Agent\Jobs
4. Right click on the Jobs folder and choose New Job. The New Job Window is displayed
5. In the Name: field, enter a name for the backup job (Ex. EVBackupJob)
6. In the Description: field enter a brief description for the backup job
7. Under Select a page, choose Steps. The Steps screen is displayed
8. Click New. The New Job Step window comes up
9. For Step name:, type in a step name, (ex. StartEVBackup)
10. For Type:, choose Transact-SQL script (T-SQL) from the list of available options.
11. For Database:, choose EnterpriseVaultDirectory from the list of available options.
12. In the Command: box, copy and paste the following query using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
7. Backups will be created in the backup location specified in Step 1.
8. For each database, a separate backup file (*.BAK) file will be created.
Automatically Performing Backups of Enterprise Vault SQL Databases Using Configured Stored Procedures
Note:
This process assumes that the SQL Server Agent is started and operational
For Microsoft SQL Server 2005/2008:
1. Create a backup location for the Enterprise Vault databases (ex. C:\Backups)
2. Open the SQL Management Studio utility
3. Browse to SQL Server Agent\Jobs
4. Right click on the Jobs folder and choose New Job. The New Job Window is displayed
5. In the Name: field, enter a name for the backup job (Ex. EVBackupJob)
6. In the Description: field enter a brief description for the backup job
7. Under Select a page, choose Steps. The Steps screen is displayed
8. Click New. The New Job Step window comes up
9. For Step name:, type in a step name, (ex. StartEVBackup)
10. For Type:, choose Transact-SQL script (T-SQL) from the list of available options.
11. For Database:, choose EnterpriseVaultDirectory from the list of available options.
12. In the Command: box, copy and paste the following query using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVDirectoryDatabaseSQLServer'
,
@BackupFolder='BackupLocation'
,
@DirectoryUser='Enterprise
Vault Service Account',
@Credential='Enterprise
Vault Service Account Password'
Example:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVSQL'
,
@BackupFolder='C:\Backups\'
,
@DirectoryUser='EVDomain\VaultAdmin',
@Credential='Password'
13. Under Select a page, choose
Advanced. The Advanced screen is
displayed
14. For On success action:, choose Quit the job reporting success
15. For On failure action:, choose Quit the job reporting failure
16. Click Ok to return to the New Job window
17. Under Select a page, choose Schedules
18. Click New and the New Job Schedule Window is displayed
19. For Name:, type in a name for the Job Schedule (ex. EVBackupSchedule)
20. For Schedule type:, choose Recurring from the list of available options
21. For Occurs:, choose a frequency (Daily, Weekly, Monthly) equivalent to the frequency of EV backups
22. For Recurs every:, choose the available options depending on the frequency of the backup
23. For Daily frequency:, choose the time the database backup should begin. This time should be in conjunction with the EV Vault Stores being placed in backup-mode
24. For Duration:, choose a start date to begin the backup
25. Click Ok twice
26. When the scheduled SQL job executes, backups will be created in the location specified in Step 12
27. For each database, a separate backup file (*.BAK) file will be created.
For Microsoft SQL Server 2000:
1. Create a backup location for the EV databases (ex. C:\Backups)
2. Open the Enterprise Manager utility
3. Browse to Management\SQL Server Agent\Jobs
4. Right click on Jobs and choose New Job. The New Job Properties window is displayed
5. In the Name: field, enter a name for the backup job (Ex. EVBackupJob)
6. In the Description: field enter a brief description for the backup job
7. Click the Steps tab. The Steps screen is displayed
8. Click New. The New Job Step window is displayed
9. For Step name:, type in a step name, (ex. StartEVBackup)
10. For Type:, choose Transact-SQL script (T-SQL) from the list of available options
11. For Database:, choose EnterpriseVaultDirectory from the list of available options
12. In the Command: box, copy and paste the following query using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
14. For On success action:, choose Quit the job reporting success
15. For On failure action:, choose Quit the job reporting failure
16. Click Ok to return to the New Job window
17. Under Select a page, choose Schedules
18. Click New and the New Job Schedule Window is displayed
19. For Name:, type in a name for the Job Schedule (ex. EVBackupSchedule)
20. For Schedule type:, choose Recurring from the list of available options
21. For Occurs:, choose a frequency (Daily, Weekly, Monthly) equivalent to the frequency of EV backups
22. For Recurs every:, choose the available options depending on the frequency of the backup
23. For Daily frequency:, choose the time the database backup should begin. This time should be in conjunction with the EV Vault Stores being placed in backup-mode
24. For Duration:, choose a start date to begin the backup
25. Click Ok twice
26. When the scheduled SQL job executes, backups will be created in the location specified in Step 12
27. For each database, a separate backup file (*.BAK) file will be created.
For Microsoft SQL Server 2000:
1. Create a backup location for the EV databases (ex. C:\Backups)
2. Open the Enterprise Manager utility
3. Browse to Management\SQL Server Agent\Jobs
4. Right click on Jobs and choose New Job. The New Job Properties window is displayed
5. In the Name: field, enter a name for the backup job (Ex. EVBackupJob)
6. In the Description: field enter a brief description for the backup job
7. Click the Steps tab. The Steps screen is displayed
8. Click New. The New Job Step window is displayed
9. For Step name:, type in a step name, (ex. StartEVBackup)
10. For Type:, choose Transact-SQL script (T-SQL) from the list of available options
11. For Database:, choose EnterpriseVaultDirectory from the list of available options
12. In the Command: box, copy and paste the following query using values for EVDirectorySQLServer, BackupFolder, DirectoryUser, and Credential specific to the Enterprise Vault environment:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVDirectoryDatabaseSQLServer'
,
@BackupFolder='BackupLocation'
,
@DirectoryUser='Enterprise
Vault Service Account',
@Credential='Enterprise
Vault Service Account Password'
Example:
exec
aspa_BackupEVDatabases
@EVDirectorySQLServer='EVSQL'
,
@BackupFolder='C:\Backups\'
,
@DirectoryUser='EVDomain\VaultAdmin',
@Credential='Password'
13. Choose the Advanced tab. The
Advanced screen is
displayed
14. For On success action:, choose Quit the job reporting success
15. For On failure action:, choose Quit the job reporting failure
16. Click Ok to return to the New Job window
17. Choose the Schedules tab. The Schedules screen is displayed
18. Click New Schedule. The New Job Schedule window is displayed
19. For Name:, type in a name for the job Schedule (Ex. EV Backup Schedule)
20. Choose Recurring | Change. The Edit Recurring Job Schedule is displayed
21. For Occurs:, choose a frequency (Daily, Weekly, Monthly) and available options equivalent to the frequency of EV backups
22. For Daily frequency, choose the time the backup should begin. This time should be in conjunction with the EV Vault Stores being placed in backup-mode
23. For Duration:, choose a start date to begin the backup
24. Click Ok 3 times
25. When the scheduled SQL job executes, backups will be created in the location specified in Step 12
26. For each database, a separate backup file (*.BAK) file will be created.
Additional Information
Administering SQL Server (SQL Server 2000) Backing Up and Restoring Databases - http://technet.microsoft.com/en-us/library/aa196685(SQL.80).aspx
SQL Server 2005 Books Online (November 2008) Backing Up and Restoring Databases in SQL Server - http://technet.microsoft.com/en-us/library/ms187048(SQL.90).aspx
SQL Server 2008 Books Online (July 2009) Backing Up and Restoring Databases in SQL Server - http://technet.microsoft.com/en-us/library/ms187048.aspx
14. For On success action:, choose Quit the job reporting success
15. For On failure action:, choose Quit the job reporting failure
16. Click Ok to return to the New Job window
17. Choose the Schedules tab. The Schedules screen is displayed
18. Click New Schedule. The New Job Schedule window is displayed
19. For Name:, type in a name for the job Schedule (Ex. EV Backup Schedule)
20. Choose Recurring | Change. The Edit Recurring Job Schedule is displayed
21. For Occurs:, choose a frequency (Daily, Weekly, Monthly) and available options equivalent to the frequency of EV backups
22. For Daily frequency, choose the time the backup should begin. This time should be in conjunction with the EV Vault Stores being placed in backup-mode
23. For Duration:, choose a start date to begin the backup
24. Click Ok 3 times
25. When the scheduled SQL job executes, backups will be created in the location specified in Step 12
26. For each database, a separate backup file (*.BAK) file will be created.
Additional Information
Administering SQL Server (SQL Server 2000) Backing Up and Restoring Databases - http://technet.microsoft.com/en-us/library/aa196685(SQL.80).aspx
SQL Server 2005 Books Online (November 2008) Backing Up and Restoring Databases in SQL Server - http://technet.microsoft.com/en-us/library/ms187048(SQL.90).aspx
SQL Server 2008 Books Online (July 2009) Backing Up and Restoring Databases in SQL Server - http://technet.microsoft.com/en-us/library/ms187048.aspx
Related Documents:
http://support.veritas.com/docs/312327
http://support.veritas.com/docs/320845
http://support.veritas.com/docs/319112
http://support.veritas.com/docs/337580
http://support.veritas.com/docs/332255
http://support.veritas.com/docs/312327
http://support.veritas.com/docs/320845
http://support.veritas.com/docs/319112
http://support.veritas.com/docs/337580
http://support.veritas.com/docs/332255
Products Applied:
Enterprise Vault for File System Archiving 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Lotus Domino 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Exchange 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Sharepoint 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for SMTP 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for File System Archiving 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Lotus Domino 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Exchange 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for Microsoft Sharepoint 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Enterprise Vault for SMTP 8.0, 8.0 SP1, 8.0 SP2, 8.0 SP3
Last Updated: February 18 2010 03:58 AM GMT
Expires on: 365 days from publish date
Subscribe to receive critical updates about this document
Expires on: 365 days from publish date
Subscribe to receive critical updates about this document
Subjects:
Enterprise Vault for File System Archiving
Administration: Backup Configuration
Enterprise Vault for Lotus Domino
Administration: Backup Configuration
Enterprise Vault for Microsoft Exchange
Administration: Backup Configuration
Enterprise Vault for Microsoft Sharepoint
Admininistration: Backup Configuration
Enterprise Vault for SMTP
Administration: Backup Configuration
Windows Server 2003
Information Development: Backing Up
Windows Server 2008
Information Development: Backing Up
Enterprise Vault for File System Archiving
Administration: Backup Configuration
Enterprise Vault for Lotus Domino
Administration: Backup Configuration
Enterprise Vault for Microsoft Exchange
Administration: Backup Configuration
Enterprise Vault for Microsoft Sharepoint
Admininistration: Backup Configuration
Enterprise Vault for SMTP
Administration: Backup Configuration
Windows Server 2003
Information Development: Backing Up
Windows Server 2008
Information Development: Backing Up
Languages:
English (US)
English (US)
Operating Systems:
Windows Server 2003
Windows Server 2003
DataCenter, DataCenter (x64), DataCenter SP1, DataCenter SP1(IA64), DataCenter SP1(x64), DataCenter SP2, Datacenter SP2(x64), Enterprise (x64), Enterprise SP1(x64), Enterprise SP2, Enterprise SP2(x64), Enterprise Server, Enterprise ServerSP1, R2, Standard Server, Standard Server SP1, Standard Server SP1 (x64), Standard Server SP2, Standard Server SP2 (x64), Standard Server(x64), Storage Server, Storage Server SP1, Storage Server SP2
Windows Server 2008
DataCenter (x64-64bit), DataCenter (x64-64bit) SP2, Enterprise (x64-64bit), Enterprise (x64-64bit) SP2, Standard (x64-64bit), Standard (x64-64bit) SP2
Symantec World Headquarters:
20330 Stevens Creek Blvd. Cupertino, CA 95014
World Wide Web: http://www.symantec.com,
Tech Support Web: http://entsupport.symantec.com,
E-Mail Support: http://seer.entsupport.symantec.com/email_forms,
FTP: ftp://ftp.entsupport.symantec.com or http://ftp.entsupport.symantec.com
20330 Stevens Creek Blvd. Cupertino, CA 95014
World Wide Web: http://www.symantec.com,
Tech Support Web: http://entsupport.symantec.com,
E-Mail Support: http://seer.entsupport.symantec.com/email_forms,
FTP: ftp://ftp.entsupport.symantec.com or http://ftp.entsupport.symantec.com
THE INFORMATION PROVIDED IN THE SYMANTEC SOFTWARE KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SYMANTEC SOFTWARE DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SYMANTEC SOFTWARE OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES,EVEN IF SYMANTEC SOFTWARE OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.