Maintenance is complete- We've moved from the saas.hpe.com domain to softwaregrp.com 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
cancel

Cannot BACKUP or RESTORE a database snapshot

Vgbg1707
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: OB2BAR_SQLBAR@sqlbicl.ccr.co.cr "(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

1 REPLY
JBasilio
Acclaimed Contributor.

Re: Cannot BACKUP or RESTORE a database snapshot

Hello

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.

https://msdn.microsoft.com/en-gb//library/ms175876(v=sql.120).aspx

Best Regards