April 3, 2009 at 4:07 am
Hi SQL gurus,
I've inherited a SQL server and am having issues to say the least. Its SQL 2000 (no SP) on Windows 2003 (no SP) and and pointers are most welcome.
Neither a Veritas Backup nor a manual backup work for one particular database.
[1] Veritas
Gives this the error below on the backup server (Backup Exec 9.0).
An error occurred on a query to database Navision Live.
Nonrecoverable I/O error occurred on file 'd:\Program Files\Microsoft SQL Server\MSSQL\data\Navision Live_1_Data.ndf'.
Database or database element is corrupt.
I initially suspected that as the Backup Exec Advanced Open File Option (AOFO) was not installed that the error was benign.
"The error refers to the instance of the file on the tape or backup to disk file. The file on the hard disk drive may be intact."
See http://seer.entsupport.symantec.com/docs/258696.htm
[2] Manual Backup:
Next I tried to backup using T-SQL but get the following error
BACKUP DATABASE Navision Live TO Navision_device
GO
Server: Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'TO'
[3] Event Viewer Error
Used the GUI to backup Navision Live (Management > Backup) but get an error:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:17055
Date:02/04/2009
Time:10:37:11
User:Domain\administrator
Computer:SQL1
Description:
18210 :
BackupIoRequest::WaitForIoCompletion: read failure on backup device 'd:\Program Files\Microsoft SQL Server\MSSQL\data\Navision Live_1_Data.ndf'. Operating system error 1117(The request could not be performed because of an I/O device error.).
[4] Error from SQL Log
BACKUP failed to complete the command BACKUP DATABASE [Navision Live] TO DISK = N'D:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\Navision Live_db_200811192152.BAK', DISK = N'D:\Backups\NavisionLive.dat' WITH NOINIT , NOUNLOAD , NAME = N'Navision Live backup', SKIP , STATS = 10, NO
*** From Event Viewer:
Event Type:Error
Event Source:MSSQLSERVER
Event Category:(6)
Event ID:17055
Date:02/04/2009
Time:12:45:14
User:Domain\administrator
Computer:SQL1
Description:
3041 :
BACKUP failed to complete the command BACKUP DATABASE [Navision Live] TO [Navision] WITH NOINIT , NOUNLOAD , NAME = N'Navision Live backup', NOSKIP , STATS = 10, NOFORMAT
[5] DBC Error
Finally I used DBCC CHECKDB ('Navision Live') With NO_INFOMSGS, TABLERESULTS gives:
Server: Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'Using'.
(15 row(s) affected)
repair_allow_data_loss is the minimum repair level for the errors found by DBCC CHECKDB (Navision Live ).
Strange thing is that users are reporting no issue with the database!
April 5, 2009 at 10:07 pm
Try this and let us know -
BACKUP DATABASE [Navision Live] TO Navision_device
GO
As name of your database contains space, sql will give syntax error, you should use square bracket "[]" to allow sql to accept database name. Although i am not sure of other errors you are getting, but your syntax for sql backup is definitely incorrectly formed. Its no harm to try this one.
April 6, 2009 at 4:13 am
Hi,
All the error message indicate one thing and that is you have got problems with your disk. The backup is failing as it is not able to read the file from the specified location.
However very strange that there are no user issues and the database is still healthy.
>> So just to cross check if the problem is with the disk, can you try coping any file to that disk and see how it goes.
>> Also not a advisable option, but if you can get some downtime. Try restarting the machine, as this could solve any glitch if any.
-Rajini
April 7, 2009 at 3:21 pm
Let's start from square one here ...
Try the following command and post the results.
BACKUP DATABASE [Navision Live] TO DISK='D:\test_navision.bak'
GO
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply