Where is the backup application log for SQL Server 2008?

sql-server logging backup
Eon picture Eon · May 10, 2012 · Viewed 82.4k times · Source

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?

Answer

maSTAShuFu picture maSTAShuFu · May 10, 2012

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

Related questions

How to see query history in SQL Server Management Studio

Is the query history stored in some log files? If yes, can you tell me how to find their location? If not, can you give me any advice on how to see it?

Read More
What is the command to truncate a SQL Server log file?

I need to empty an LDF file before sending to a colleague. How do I force SQL Server to truncate the log?

Read More
SQL Server stops loading assembly

We have developed an assembly for SQL Server 2008 R2. The assembly has been working for a week. The managed stored proc inside the assembly was working fine for the whole week and then it stops working. We have been seeing …

Read More