Host-based backup of VMware vSphere VMs.
Post Reply
Igomezs
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 5:37 pm
Contact:

Error restoring objects in SQL replicated database

Post by Igomezs »

Hi,

I have a customer with a problem restoring objects in a sql replicated database. When we attempt to restore and schema and data veeam said Unable to attach database, see log for details.

When we enter to the logs we found an error that said: Cannot drop the database xxxxxx because it is being user for replication.

We dont have problems restoring objects from other databases wich are not replicated, what can i do?

We dont open a case yet because we dont now if its a issue with sql configuration or with veeam

The customer support ID is 00571057

Thanks
Shestakov
Veteran
Posts: 7328
Liked: 781 times
Joined: May 21, 2014 11:03 am
Full Name: Nikita Shestakov
Location: Prague
Contact:

Re: Error restoring objects in SQL replicated database

Post by Shestakov »

Hi, what product version are you at?
Please contact technical support and provide support case number as stated in the forum`s rules when asking a question about technical error.
Thanks!
Igomezs
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 5:37 pm
Contact:

Re: Error restoring objects in SQL replicated database

Post by Igomezs »

Customers version is 9 and case number is 01706097.

We can restore all databases without problem but with one witch is replicated to other sql with sql replication we have the error.

Te sql replication is needed for customers web.

Thanks
Igomezs
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 5:37 pm
Contact:

Re: Error restoring objects in SQL replicated database

Post by Igomezs »

Veeam can do granular restore from sql replicated database?

Please tell us because the reply in the incidence was stop or disable relpication

Thanks
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Error restoring objects in SQL replicated database

Post by foggy »

Veeam B&R can restore objects from a replicated database, but to an alternative location only. So you can either specify another database as restore target or disable replication, if restore to original location is required.
Igomezs
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 5:37 pm
Contact:

Re: Error restoring objects in SQL replicated database

Post by Igomezs »

I have the same issue exporting schema or data.......
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Error restoring objects in SQL replicated database

Post by foggy »

Do you mean restore to an alternate location results in a similar error message?
Igomezs
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 5:37 pm
Contact:

Re: Error restoring objects in SQL replicated database

Post by Igomezs »

I have the same problem restoring to the same sql, alternate sql or exporting schema or data
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Error restoring objects in SQL replicated database

Post by foggy »

Have you tried specifying different database name? Do you see similar error message while trying to export data or a different one?
Igomezs
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 5:37 pm
Contact:

Re: Error restoring objects in SQL replicated database

Post by Igomezs »

I have the same message in the log with the 3 operations. Cannot drop database xxxxxx because is being used for replication
foggy
Veeam Software
Posts: 21069
Liked: 2115 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Error restoring objects in SQL replicated database

Post by foggy »

Then please continue working with support on this, logs need to be investigated.
Post Reply

Who is online

Users browsing this forum: Baidu [Spider] and 72 guests