Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
singlehouse03
Starting Member
2 Posts |
 Posted - 2011-10-05 : 11:43:40
|
Schedule transcation log backup always failed although I can backup manually. I find the following error message but not sure how to troubleshoot. Here is error message:Date 10/5/2011 11:20:00 AMLog Job History (trn backup.Subplan_1)Step ID 1Server HSCSORDBCPA\HSCSORDBCPAJob Name trn backup.Subplan_1Step Name Subplan_1Duration 00:00:08Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: HSCDOM\SQLSVCMGRORCL. ... Package Utility Version 9.00.5000.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 11:20:01 AM Progress: 2011-10-05 11:20:06.63 Source: {22C8D3DA-21F9-4142-A002-18D34FC38D71} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2011-10-05 11:20:07.63 Source: Back Up Database (Transaction Log) Executing query "EXECUTE master.dbo.xp_create_subdir N'G:\Microsoft".: 100% complete End Progress Error: 2011-10-05 11:20:07.80 Code: 0xC002F210 Source: Back Up Database (Transaction Log) Execute SQL Task Description: Executing the query "BACKUP LOG [MonitorCapture] TO DISK = N'G:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup\MonitorCapture\MonitorCapture_backup_201110051120.trn' WITH RETAINDAYS = 2, NOFORMAT, NOINIT, NAME = N'MonitorCapture_backup_20111005112007', SKIP, REWIND, NOUNLOAD, STATS = 10 " failed with the followin. The step failed. |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-10-05 : 13:18:22
|
| make sure HSCDOM\SQLSVCMGRORCL has write permission on folder where you are taking backup. |
 |
|
|
|
|
|
scheduled transaction log backup failed