SQL Server 2008的备份应用程序日志在哪里? [英] Where is the backup application log for SQL Server 2008?

问题描述

我需要检查为什么其中一个系统的数据库备份失败.

I need to check out why a database backup failed in one of our systems.

日志显示以下内容:

BACKUP无法完成命令BACKUP LOG XXXXXX.检查 备份应用程序日志以获取详细消息.

BACKUP failed to complete the command BACKUP LOG XXXXXX. Check the backup application log for detailed messages.

我进入了Windows事件日志，检查了应用程序日志，并猜测我在那些日志中发现的针对此特定错误的内容

I went into Windows event logs , checked the application logs, and guess what I have found for this specific error in those logs

BACKUP无法完成命令BACKUP LOG XXXXXX.检查 备份应用程序日志以获取详细消息.

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?

推荐答案

打开SSMS并连接到数据库 转到管理>维护计划>选择您的备份计划. >右键单击并查看历史记录.

open SSMS and connect to the database go to MANAGEMENT > MAINTENANCE PLAN > pick your backup plan. > right click and view history.

或访问管理> sql服务器日志.

or to MANAGEMENT > sql server logs.

目录位置:c:\Program Files\Microsoft SQL Server\MSSQL.xx\MSSQL\LOG

这篇关于SQL Server 2008的备份应用程序日志在哪里?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！