Error restoring objects in SQL replicated database

VMware specific discussions

Error restoring objects in SQL replicated database

Veeam Logoby Igomezs » Sun 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
Igomezs
Novice
 
Posts: 9
Liked: never
Joined: Sun Feb 21, 2016 5:37 pm

Re: Error restoring objects in SQL replicated database

Veeam Logoby Shestakov » Mon 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!
Shestakov
Veeam Software
 
Posts: 4842
Liked: 393 times
Joined: Wed May 21, 2014 11:03 am
Location: Saint Petersburg
Full Name: Nikita Shestakov

Re: Error restoring objects in SQL replicated database

Veeam Logoby Igomezs » Mon 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: Sun Feb 21, 2016 5:37 pm

Re: Error restoring objects in SQL replicated database

Veeam Logoby Igomezs » Wed 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
Igomezs
Novice
 
Posts: 9
Liked: never
Joined: Sun Feb 21, 2016 5:37 pm

Re: Error restoring objects in SQL replicated database

Veeam Logoby foggy » Wed 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.
foggy
Veeam Software
 
Posts: 14716
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Error restoring objects in SQL replicated database

Veeam Logoby Igomezs » Wed Feb 24, 2016 11:41 am

I have the same issue exporting schema or data.......
Igomezs
Novice
 
Posts: 9
Liked: never
Joined: Sun Feb 21, 2016 5:37 pm

Re: Error restoring objects in SQL replicated database

Veeam Logoby foggy » Wed Feb 24, 2016 11:43 am

Do you mean restore to an alternate location results in a similar error message?
foggy
Veeam Software
 
Posts: 14716
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Error restoring objects in SQL replicated database

Veeam Logoby Igomezs » Wed Feb 24, 2016 11:56 am

I have the same problem restoring to the same sql, alternate sql or exporting schema or data
Igomezs
Novice
 
Posts: 9
Liked: never
Joined: Sun Feb 21, 2016 5:37 pm

Re: Error restoring objects in SQL replicated database

Veeam Logoby foggy » Thu 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?
foggy
Veeam Software
 
Posts: 14716
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson

Re: Error restoring objects in SQL replicated database

Veeam Logoby Igomezs » Thu 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
Igomezs
Novice
 
Posts: 9
Liked: never
Joined: Sun Feb 21, 2016 5:37 pm

Re: Error restoring objects in SQL replicated database

Veeam Logoby foggy » Thu Feb 25, 2016 10:25 am

Then please continue working with support on this, logs need to be investigated.
foggy
Veeam Software
 
Posts: 14716
Liked: 1075 times
Joined: Mon Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson


Return to VMware vSphere



Who is online

Users browsing this forum: No registered users and 22 guests