Availability for the Always-On Enterprise
Post Reply
arosas
Enthusiast
Posts: 26
Liked: 5 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

SQL DB Restore Enterprise manager duplicate DB names

Post by arosas » Apr 06, 2017 2:55 pm

I'm wondering if anyone can give their input on removing duplicate DB entries in Enterprise Manager? When selecting the duplicate DB listed we receive "Database was not found."
I have a good guess as to why there are duplicates.

We backed up a SQL production server a certain way for testing. Once we were done with testing we deleted the job and deleted the data from our backup repository.
We then added this SQL server to an existing job that has been backing up.

I'm guessing the duplicate is because of the first job setup and this is contained in the history even though the data is gone.

The steps to recreate the issue are:
Enterprise manager>Items>SQL Databases
Click "or pick server..." link
Select the SQL server in question.
All DBs are listed including the duplicates.
Select one of the duplicates and the error will pop up.

Thanks for any input.

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

Re: SQL DB Restore Enterprise manager duplicate DB names

Post by foggy » Apr 06, 2017 3:49 pm

Hi Tony, have you tried to rescan the repository and then perform data collection in EM? If this doesn't help, please contact tech support.

arosas
Enthusiast
Posts: 26
Liked: 5 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

Re: SQL DB Restore Enterprise manager duplicate DB names

Post by arosas » Apr 06, 2017 4:02 pm

Thanks for the suggestion, but that didn't make a difference. I'll open up a support ticket on this.

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

Re: SQL DB Restore Enterprise manager duplicate DB names

Post by foggy » Apr 06, 2017 4:04 pm

I'd appreciate if you come back with the results of investigation or at least share the case ID for further reference. Thanks.

arosas
Enthusiast
Posts: 26
Liked: 5 times
Joined: Jun 09, 2015 9:33 pm
Full Name: Tony Rosas
Contact:

Re: SQL DB Restore Enterprise manager duplicate DB names

Post by arosas » Apr 06, 2017 8:28 pm 1 person likes this post

Case: 02122159
Support clarified: EM uses the setting Guest File System Catalog. When it reaches the time frame we should no longer see the duplicate DBs.

https://helpcenter.veeam.com/docs/backu ... tml?ver=95

Post Reply

Who is online

Users browsing this forum: AndrewPBG, Bing [Bot], daniel.triplehorn, ManOrs and 58 guests