Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backup fails - HRESULT:0x80040cc7 3

Status
Not open for further replies.

jondooley

Technical User
Dec 13, 2004
1
GB
Hi

I can't find anything to let me know why this backup to TSM has started to fail. Below in information from the backup log:

12-12-2004 23:25:16 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040cc7)
12-12-2004 23:25:17 ACO5436E A failure occurred on stripe number (0), rc = 428
12-12-2004 23:25:17 ACO5407E The SQL server aborted the operation.
12-12-2004 23:25:17 Backup of MSATravelLeads failed.
12-12-2004 23:25:17 ACO5422E Received the following from the MS SQL server:
12-12-2004 23:25:17 [Microsoft][ODBC SQL Server Driver][SQL Server]Nonrecoverable I/O error occurred on file 'F:\Program Files\Microsoft SQL Server\MSSQL\data\MSATravelLeads_Data.MDF'.
12-12-2004 23:25:17 [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally. Microsoft SQL-DMO (ODBC SQLState: 42000) (HRESULT:0x80040cc7)
12-12-2004 23:25:18 ACO5436E A failure occurred on stripe number (0), rc = 428
12-12-2004 23:25:18 ACO5407E The SQL server aborted the operation.


These errors are the same for all 14 databases.

Does anybody have any ideas???
 
First item of business you should do is run a

DBCC CheckDB(*) -- Where * is the name of the DB

Lets see what type of error we get if any.

Thanks

J. Kusch
 
what raid are you using? either a drive is bad or your raid controller is having problems (hope you used hardware raid) i dont think it is a sql issue persay. its more of an os/hardware issue. work with your server admin to figure the problem out. he should be able to check out the drives.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top