Discussions specific to the VMware vSphere hypervisor
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 » Feb 21, 2016 5:47 pm

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
Veeam Software
Posts: 6832
Liked: 696 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 » Feb 22, 2016 11:32 am

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 » Feb 22, 2016 4:17 pm

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 » Feb 24, 2016 10:03 am

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: 18030
Liked: 1533 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Error restoring objects in SQL replicated database

Post by foggy » Feb 24, 2016 11:11 am

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 » Feb 24, 2016 11:41 am

I have the same issue exporting schema or data.......

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

Re: Error restoring objects in SQL replicated database

Post by foggy » Feb 24, 2016 11:43 am

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 » Feb 24, 2016 11:56 am

I have the same problem restoring to the same sql, alternate sql or exporting schema or data

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

Re: Error restoring objects in SQL replicated database

Post by foggy » Feb 25, 2016 7:58 am

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 » Feb 25, 2016 10:24 am

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: 18030
Liked: 1533 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Error restoring objects in SQL replicated database

Post by foggy » Feb 25, 2016 10:25 am

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

Post Reply

Who is online

Users browsing this forum: dantoncancella, Frohn, ncapponi, reiso22 and 44 guests