Skip to main content
Question

DB instance failing to backup

  • 23 September 2024
  • 2 replies
  • 153 views

SivaShankarBehera
Forum|alt.badge.img+3

Hi 

 

DB type- SQL

I have a DB server, and I am trying to take a DB aware backup.

For one of its DB i received an error as below.

Error encountered during backup. Error Code: [9001 - Microsoft.SqlServer.Management.Common.ExecutionFailureException:The log for database 'Engage' is not available. Check the event log for related error messages. Resolve any errors and restart the database. A nonrecoverable I/O error occurred on file "ebd391bc-0029-4c57-88ee-c1ca5bc08102:" 995(The I/O operation has been aborted because of either a thread exit or an application request.). BACKUP DATABASE is terminating abnormally. An exception occurred while executing a Transact-SQL statement or batch.]

 

Error received for DB server.

Error summary

Error code: [30:324]

Description: Error encountered when closing the virtual device. Please see SQL Server vdi.log for more details.
Source: DB server, Process: SQLBackup

 

 

 

 

2 replies

Forum|alt.badge.img+7
  • Vaulter
  • 68 replies
  • September 24, 2024

Hi @SivaShankarBehera 
Microsoft SQL Server is returning the error during the attempt to backup the database.

please share SQLBACKUP.log from client DB server possible to check for more details.

More details of exception to see cause and resolution steps
https://learn.microsoft.com/en-us/sql/relational-databases/errors-events/mssqlserver-9001-database-engine-error?view=sql-server-ver16

 

 







 


Forum|alt.badge.img+14

@SivaShankarBehera  

This is your issue “The log for database 'Engage' is not available.”

This message is being returned from MSSQL server. There is an issue with the log file for that database you will see that same message in Windows application log as well. Any backup even a native backup will return that same failure. Usually, a reboot or taking the database offline then bring it back online but that is a query for MSFT.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings