Host-based backup of VMware vSphere VMs.
Post Reply
gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 »

Hi All,

Hope you are doing well..!!
Today we got new error for SQL TLOG Backup on one of the server.
Error is: "Sequence contains no elements"
"Transaction logs for the following databases were not backed up: master;model;msdb;dbm;informatica961_prod_audit;informatica961_prod_domain;informatica961_prod_hts;informatica961_prod_mmbg;informatica961_prod_mrs;informatica961_prod_rdl;informatica961_prod_rep1;informatica961_prod_rep2"

Please help me if any one has idea about this error.


Thanks,
Vijay G
gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 »

Please help
nielsengelen
Product Manager
Posts: 5797
Liked: 1215 times
Joined: Jul 15, 2013 11:09 am
Full Name: Niels Engelen
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by nielsengelen »

Did the backups work fine before on these databases? If it worked fine I would advise to open a support call to see why this happened.
Personal blog: https://foonet.be
GitHub: https://github.com/nielsengelen
gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 » 2 people like this post

Yeah. it was resolved.
There was a bug with 9.5 version update 3.
We have installed hotfox on this version. after that issue was fixed.

Thanks,
Vijay G
btanguay
Influencer
Posts: 18
Liked: 2 times
Joined: Nov 28, 2014 6:58 pm
Full Name: Benoit Tanguay
Location: Boucherville, QC, Canada
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by btanguay »

Can you provide the hotfix number and/or your support call number for reference?
I'm having the same issue just after upgrading to update 3.
Benoit.
veremin
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by veremin »

Shared the case ID via PM. Check your inbox. Thanks.
spawnxx
Lurker
Posts: 1
Liked: never
Joined: May 03, 2018 12:43 pm
Full Name: Pascal
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by spawnxx »

Hi, I have the exact same problem. Everything was working properly for the last few weeks. What is the solution for this please?
hongt2k
Novice
Posts: 3
Liked: never
Joined: May 09, 2018 7:35 pm
Full Name: Tony
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by hongt2k »

What is the hotfix for this issue? I am experiencing the same problem.
foggy
Veeam Software
Posts: 21139
Liked: 2141 times
Joined: Jul 11, 2011 10:22 am
Full Name: Alexander Fogelson
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by foggy »

Guys, please contact technical support directly to verify the issue and get the hotfix. Thanks.
gouvi04
Influencer
Posts: 21
Liked: 4 times
Joined: Jun 21, 2017 10:17 am
Full Name: Vijay Kumar
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by gouvi04 » 1 person likes this post

thong@qcc.cuny.edu wrote:Thank you for contacting Veeam Support.
As we discussed on the phone, the behaviour is a known issue according to the information you have provided.

Please download the hotfix from the link as below,
#Removed by MOD (Outdated hotfix)

and follow the direction as below, (Do NOT skip any steps as it may need to go back to the original dll some cases)

1. Stop Veeam service
Get-Service veeam* | Stop-Service

2. Rename the original Veeam.Backup.Core.dll in C:\Program Files\Veeam\Backup & Replication\Backup
Rename-Item -Path "C:\Program Files\Veeam\Backup and Replication\Backup\Veeam.Backup.Core.dll" -NewName "Veeam.Backup.Core.dll_orig"

3. Replace Veeam.Backup.Core.dll from the fix;

4. Start Veeam service
Get-Service veeam* | Start-Service

Please let us know how you go.
MrMegaVadim
Novice
Posts: 6
Liked: 4 times
Joined: Jun 27, 2016 1:48 pm
Full Name: Vadim
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by MrMegaVadim »

AMASING SOLUTION

WORKED LIKE A CHARM AS IT IS !!!
channdeep
Lurker
Posts: 2
Liked: 3 times
Joined: Feb 17, 2018 7:40 pm
Full Name: Channdeep Singh
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by channdeep » 1 person likes this post

TLOG backups worked for me also after installing this hotfix. Thanks a lot.
Armonea
Lurker
Posts: 2
Liked: never
Joined: Aug 10, 2017 1:01 pm
Full Name: Armonea Support
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by Armonea »

Applying this fix caused the service start to fail.
Did not work anymore => no fix for me...
wishr
Veteran
Posts: 3077
Liked: 455 times
Joined: Aug 07, 2018 3:11 pm
Full Name: Fedor Maslov
Contact:

Re: Sequence contains no elements error on SQL TLOG Backup

Post by wishr »

Hi Armonia,

In this case, please raise a support case and work with our engineers directly to get it fully resolved.

Thanks
Post Reply

Who is online

Users browsing this forum: AdsBot [Google] and 31 guests