<div>
please take a look on this helpful article <a href="https://portal.databasemart.com/kb/a155/sql-server-backup-database-is-terminating-abnormally-problems-with-query-resultset.aspx" rel="ugc">https://portal.databasemar<wbr />t.com/kb/a<wbr />155/sql-se<wbr />rver-backu<wbr />p-database<wbr />-is-termin<wbr />ating-abno<wbr />rmally-pro<wbr />blems-with<wbr />-query-res<wbr />ultset.asp<wbr />x</a>
</div>


<div>
Hi Jason,<br />
<br />
No fix. Any other ideas?<br />
<br />
Thank you.
</div>


<div>
Hi hellworld12345<br />
<br />
Check the parameters those you have passed in the SSIS package. Because sometimes, the number of parameters doesn’t match, at that time you can get the above error.
</div>


<div>
Hi Jason,<br />
<br />
My apologies for the late reply what do you mean by &quot;check the parameters those you have passed in the SSIS package&quot;?<br />
<br />
Thank you.
</div>


<div>
<blockquote>
I have checked the database backups and they are performing as required 
</blockquote>
Where did you check the backups from?<br />
How many databases do you have and how many is returning that error?<br />
You sure that you're backing up all databases? Didn't you miss some?
</div>


<div>
Hi Victor,<br />
<br />
Where did you check the backups from?<br />
- From the jobs logs and the physical location.<br />
<br />
- How many databases do you have and how many is returning that error?<br />
52 and 3 are returning the error.<br />
<br />
- You sure that you're backing up all databases? Didn't you miss some?<br />
Verified they all are being backed up. <br />
<br />
Thank you.
</div>


<div>
Can you run the following and post here the result of the query?<br />

<pre><code class="code-1 nolinks" id="code-20-41764961-1"><span>USE msdb</span>
<span>GO</span>
<span></span>
<span>SELECT name, backup_finish_date, server_name, database_name, recovery_model</span>
<span>FROM backupset</span>
<span>WHERE database_name IN ('DatabaseName1', 'DatabaseName2', 'DatabaseName3') AND type='D'</span>
</code></pre>
NOTE: Replace 'DatabaseName1', 'DatabaseName2', 'DatabaseName3' with the 3 databases names that are returning error.
</div>


<div>
SELECT TOP (10) bs.*<br />
FROM msdb.dbo.backupset bs<br />
WHERE bs.database_name IN ('&lt;db_name_of_failed_backu<wbr />p&gt;')<br />
ORDER BY bs.backup_finish_date DESC<br />
<br />
If you get recent results, look at the type of backups. &nbsp;If they are type &quot;D&quot; but &quot;is_copy_only&quot; is 1, then you have the wrong type of backup being taken.
</div>


<div>
Thank you for that I checked if any new jobs were created. One my colleagues created &nbsp;a script that switching the databases on an interval basis and forgot to disable it.
</div>


<div>
<div class="content wysiwyg-content">
Heyas,<br />
<br />
I am getting the following error:<br />
<br />
\\SQLTrnLog...&quot; failed with the following error: &quot;BACKUP LOG cannot be performed because there is no c.urrent database backup<br />
BACKUP LOG is terminating abnormally.&quot;. Possible failure reasons: Problems with the query, &quot;ResultSet&quot; property not set correctly, parameters not set correctly, or connection not established correctly.<br />
<br />
I have checked the database backups and they are performing as required why can't the Transaction Log job (Created via the maintenance plan find these backups)<br />
<br />
Thank you.
</div>
</div>


Heyas,

I am getting the following error:

\\SQLTrnLog..." failed with the following error: "BACKUP LOG cannot be performed because there is no c.urrent database backup
BACKUP LOG is terminating abnormally.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

I have checked the database backups and they are performing as required why can't the Transaction Log job (Created via the maintenance plan find these backups)

Thank you.

Transaction Log Backups are failing because it can't find the associated backup.

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.