Maintenance is complete- We've moved from the domain to click to read more
As part of our journey to complete our separation work and our future integration with Micro Focus, we've now updated our domain for the community. This is an interim step, which will be followed by a series of future update / improvements: - Piloting Idea boards - Refreshing the entire UI. (more to come later) - and more
Data Protector Practitioners Forum

Cannot BACKUP or RESTORE a database snapshot

New Member.

Cannot BACKUP or RESTORE a database snapshot

<I have problem with sql integration, at backup time show me the following error:


[Critical] From: "(DEFAULT)"  Time: 2/1/2016 5:04:34 AM

      Error has occurred while executing a SQL statement.

      Error message: 'SQLSTATE:[42000] CODE:(3002) MESSAGE:[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot BACKUP or RESTORE a database snapshot.

SQLSTATE:[42000] CODE:(3013) MESSAGE:[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally

Acclaimed Contributor.

Re: Cannot BACKUP or RESTORE a database snapshot


You are trying to backup database snapshot this is not supported by DP. You must exclude or remove snapshot databse using SQL query due is not possible do it from SQl management Studio.

Best Regards