SQL DB Restore Enterprise manager duplicate DB names

Availability for the Always-On Enterprise

SQL DB Restore Enterprise manager duplicate DB names

Veeam Logoby arosas » Thu 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.
arosas
Influencer
 
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas

Re: SQL DB Restore Enterprise manager duplicate DB names

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

Re: SQL DB Restore Enterprise manager duplicate DB names

Veeam Logoby arosas » Thu 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.
arosas
Influencer
 
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas

Re: SQL DB Restore Enterprise manager duplicate DB names

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

Re: SQL DB Restore Enterprise manager duplicate DB names

Veeam Logoby arosas » Thu 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
arosas
Influencer
 
Posts: 21
Liked: 4 times
Joined: Tue Jun 09, 2015 9:33 pm
Full Name: Tony Rosas


Return to Veeam Backup & Replication



Who is online

Users browsing this forum: iostrikov, mairj, odruard, salyerma, Yahoo [Bot] and 55 guests