Menu
I need to check out why a database backup failed in one of our systems.
The log says the following:
BACKUP failed to complete the command BACKUP LOG XXXXXX. Check the backup application log for detailed messages.
I went into Windows event logs , checked the application logs, and guess what I have found for this specific error in those logs
BACKUP failed to complete the command BACKUP LOG XXXXXX. Check the backup application log for detailed messages.
Where is the actual backup application log stored at by default?
785
open SSMS and connect to the database go to MANAGEMENT > MAINTENANCE PLAN > pick your backup plan. > right click and view history. or to MANAGEMENT > sql server logs.
On the Search bar, type Event Viewer, and then select the Event Viewer desktop app. In Event Viewer, expand the Windows Logs folder, and select the Application event log. SQL Server events are identified by the entry MSSQLSERVER (named instances are identified with MSSQL$<instance_name>) in the Source column.
Windows Backup keeps log files in "C:\Windows\Logs\WindowsBackups" by default. You may not be able to see this folder or its contents if you aren't an administrator on your computer.
Using SQL Server Management StudioRight-click the database you want to backup, point to Tasks, and then click Back Up. The Back Up Database dialog box appears. In the Destination section of the General page, click either Disk or Tape. In the Back up to list box, look for the disk file or tape you want.
open SSMS and connect to the database go to MANAGEMENT > MAINTENANCE PLAN > pick your backup plan. > right click and view history.
or to MANAGEMENT > sql server logs.
directory location : c:\Program Files\Microsoft SQL Server\MSSQL.xx\MSSQL\LOG
135
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
