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.
[flush]
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.
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.
[flush]
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.