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 |
|
Abu-Dina
Posting Yak Master
206 Posts |
 Posted - 2010-07-29 : 09:13:08
|
| Hi all, hope you're all well.I have been asked to investigate why a certain backup job has been failing.So far I have found the following but to be truthful I'm not sure what it all means. if anyone can help explain this to me I'd be grateful.Thanks in advance.Date 10/06/2010 00:00:00Log Job History (Daily Backups.Subplan_1)Step ID 1Server IDISADBSRV01Job Name Daily Backups.Subplan_1Step Name Subplan_1Duration 00:00:36Sql Severity 0Sql Message ID 0Operator Emailed Operator Net sent Operator Paged Retries Attempted 0MessageExecuted as user: ISLINGTON\svc_contemp. ...Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 00:00:00 Progress: 2010-06-10 00:00:11.78 Source: {98BCE22D-CC8E-49A3-879C-A200154891AB} Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress Progress: 2010-06-10 00:00:12.69 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\SQL Serve".: 33% complete End Progress Progress: 2010-06-10 00:00:12.69 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\SQL Serve".: 66% complete End Progress Progress: 2010-06-10 00:00:12.69 Source: Back Up Database (Full) Executing query "EXECUTE master.dbo.xp_create_subdir N'E:\SQL Serve".: 100% complete End Progress Progress: 2010-06-10 00:00:14.03 Source: Back Up Database (Full) Executing query "BACKUP DATABASE [DIREPO. The step failed. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-07-29 : 13:38:17
|
| what do u see in eventvwr and sql error logs? |
 |
|
|
|
|
|
Backup job failing - need assistance