修正SQL Server事务日志备份/截断的JOB错误

HyperWang

于 2016-02-04 10:45:45 发布

阅读量3.3k

点赞数 1

分类专栏： SQL Server 文章标签： sql server 事务日志完整备份截断 log-backup

本文链接：https://blog.csdn.net/wstoneh01/article/details/50633952

版权

问题描述

通过SSMS中的维护计划配置了事务日志（Transaction Log）备份的Job，但测试执行后出现如下报错信息：

Date        2/4/2016 8:00:00 AM
Log     Job History (backup_log.sub)

Step ID     1
Server      MAXIMO75
Job Name        backup_log.sub
Step Name       sub
Duration        00:00:02
Sql Severity        0
Sql Message ID      0
Operator Emailed        
Operator Net sent       
Operator Paged      
Retries Attempted       0

Message
Executed as user: WORKGROUP\MAXIMO75$. Microsoft (R) SQL Server Execute Package Utility  Version 10.50.4000.0 for 64-bit  Copyright (C) Microsoft Corporation 2010. All rights reserved.    Started:  8:00:00 AM  Progress: 2016-02-04 08:00:01.74     Source: {3EC7849D-C143-4091-99DB-8AADBABF5164}      Executing query "DECLARE @Guid UNIQUEIDENTIFIER      EXECUTE msdb..sp...".: 100% complete