Backup Failing
Backup Failing
(OP)
Hoping someone can help. We are having an issue all of a sudden that our backups are failing. We are using SQL Server 2008 R2. Here is a copy of the backup log:
Any help will be greatly appreciated.
Microsoft(R) Server Maintenance Utility (Unicode) Version 10.50.1600
Report was generated on "RX510001".
Maintenance Plan: SendSuiteLiveBackup
Duration: 00:23:08
Status: Warning: One or more tasks failed.
Details:
Back Up Database (Full) (RX510001)
Backup Database on Local server connection
Databases: SendSuiteLive
Type: Full
Append existing
Task start: 2014-10-17T02:00:04.
Task end: 2014-10-17T02:23:12.
Failed:(-1073548784) Executing the query "BACKUP DATABASE [SendSuiteLive] TO DISK = N'F:\\\\S..." failed with the following error: "Read on "C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\SendSuiteLive.mdf" failed: 23(Data error (cyclic redundancy check).)
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:EXECUTE master.dbo.xp_create_subdir N''F:\\SendSuiteLive''
GO
BACKUP DATABASE [SendSuiteLive] TO DISK = N''F:\\SendSuiteLive\SendSuiteLive_backup_2014_10_17_020004_1727730.bak'' WITH RETAINDAYS = 5, NOFORMAT, NOINIT, NAME = N''SendSuiteLive_backup_2014_10_17_020004_1571727'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
Report was generated on "RX510001".
Maintenance Plan: SendSuiteLiveBackup
Duration: 00:23:08
Status: Warning: One or more tasks failed.
Details:
Back Up Database (Full) (RX510001)
Backup Database on Local server connection
Databases: SendSuiteLive
Type: Full
Append existing
Task start: 2014-10-17T02:00:04.
Task end: 2014-10-17T02:23:12.
Failed:(-1073548784) Executing the query "BACKUP DATABASE [SendSuiteLive] TO DISK = N'F:\\\\S..." failed with the following error: "Read on "C:\\Program Files\\Microsoft SQL Server\\MSSQL10_50.MSSQLSERVER\\MSSQL\\DATA\\SendSuiteLive.mdf" failed: 23(Data error (cyclic redundancy check).)
BACKUP DATABASE is terminating abnormally.
10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Command:EXECUTE master.dbo.xp_create_subdir N''F:\\SendSuiteLive''
GO
BACKUP DATABASE [SendSuiteLive] TO DISK = N''F:\\SendSuiteLive\SendSuiteLive_backup_2014_10_17_020004_1727730.bak'' WITH RETAINDAYS = 5, NOFORMAT, NOINIT, NAME = N''SendSuiteLive_backup_2014_10_17_020004_1571727'', SKIP, REWIND, NOUNLOAD, STATS = 10
GO
Any help will be greatly appreciated.
DBAMJA
It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.
Talk To Other Members
RE: Backup Failing
CODE
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
RE: Backup Failing
There were also several errors just before this in the application log that looked like this:
Thanks for your assistance.
DBAMJA
It is said that God will give you no more than you can handle. I just wish God didn't have so much faith in me.
RE: Backup Failing
-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom