Data Protector Practitioners Forum
cancel

Cannot BACKUP or RESTORE a database snapshot

Vgbg1707
Acclaimed Contributor

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
Honored 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

//Add this to "OnDomLoad" event