error 9001

Question

Post reply

error 9001

Robert Lu

SSCrazy

Points: 2428
More actions
November 15, 2004 at 1:01 pm

#182945

Hi sql guru,
I need your help.
After rebooting our cluster server (sql 2k on win 2k with latest
sp) the following error comes out:
operating system error 1117(the request could not be performed becouse of an I/O device error.) on device'(our share drive)' duringReadFileHdr.
actually this error comes up before recovery completed.
I checked sql errors :Error9001:The log for database(dbname) is not available.
Some of our databases log backup were failed with the same error.
I try to recteated the maintenance plan. no use.
Please help. Thanks in advance.

Robert

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Max-146500 SSCarpal Tunnel Points: 4691 More actions · Answer 1

Hi Robert

Are your .ldf's physically on file?

I found this article on msdn, which does offers an interesting insight into a potential issue you may want to address with your connections: http://support.microsoft.com/default.aspx?scid=kb;en-us;811476

Another guess is that your HD has been corrupted or damaged. Are your log files on a different disk (perhaps mounted drive and is there any hardware redundancy)?

Here's another item that I found: http://support.microsoft.com/default.aspx?scid=kb;en-us;299685

Please check that you have installed the latest sp for sql 2k which is sp3a.

Hope this helps

Max

SQLBill SSC Guru Points: 51440 More actions · Answer 2

You need to give us more information about your setup.

You have a cluster, so you are using shared drives. Are the log files on the shared drives?

-SQLBill

sa24 SSCrazy Eights Points: 8027 More actions · Answer 3

SQL Server needs to have all the drives which it would be using included under resource depenedencies. Can you verify the dependencies are still in place. Also verify that the disk integrity.

Robert Lu SSCrazy Points: 2428 More actions · Answer 4

Thanks for all reply.

We applied the latest sp which is sp3a.

The log file is on the drive which is under dependency.

I checked this article:

http://support.microsoft.com/default.aspx?kbid=828339

And I did dbcc checkdb. The database is not corrupted.

So I guess maybe it's a HD problem. I should discuss with

our system admin.

The strange thing is when I recreate maintenance plan, this error would happen to another database and find a new error:

Could not clear 'DIFF' bitmap in database 'dbname' due to error 9001. A subsequent backup operation may be slower/larger than normal.

Does anyone have the same problem?

Thanks!

Robert

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 5

Make sure the drive which hosts your database log files is accessable.

Post your SQL Server errorlog here too.

Robert Lu SSCrazy Points: 2428 More actions · Answer 6

Thanks Allen. Yes, actually the drive hosts many database files, log files and even some backups. Only one database backup failed, but the transaction log backup is completed successfully. The error message is still 9001.

Robert

Robert Lu SSCrazy Points: 2428 More actions · Answer 7

Sorry I forgot to post the error message:

backup backup failed to completethe command backup database (dbname) to disk (the share drive).......

spid60 The log for database (dbname) is not available.

spid60 Error: 9001, severty:21, State: 1

spid60 Could not clear 'DIFF"bitmap in database"dbname" due to error 9001. a subsequent.......

any thoughts? Thanks!

Robert

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 8

I suspect this database is inaccessable, Can you confirm that?

Robert Lu SSCrazy Points: 2428 More actions · Answer 9

Yes, the database is accessable. I can query from EM.

Robert

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 10

Can you post the result back of "dbcc sqlperf (logspace)" and indicate which log file is for that database? Did you perform full or differentail backup when you received the error message?

Johan Bijnens SSC Guru Points: 135265 More actions · Answer 11

Can you force a table-scan on all tables of your db ?

select * from yourtable

Why : so no indexes (except clusterd) are used and only datapages are accessed. This way you know you still have all data. So this way you can find out which tables are affected. Perform it one by one.

I have had a situation where a db was accessable, but not all tables. So it spitted out errors. Unfortunatly the dba did not make any backups. By selecting all from single tables at a time, we managed to transfer the tables to a new (work) database and we could manualy recreate the affected tables (wich were aggregate tables, so the data could be rebuild).

After the system was back up and running, backups were put in place. fortunatly

A couple of weeks later, the harddisk crashed. Maybe that incident was an omen

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

Robert Lu SSCrazy Points: 2428 More actions · Answer 12

Hi Allen,

I run dbcc sqlperf(logspace)

The results shows the log file is there.

12 (dbname) 9.9921875 23.089327 0

Totally we have 13 databases including system databases.

the one with problem is 12th.

Alzdba,

This db has many tables. I will try your suggestion.

Thanks!

Robert

Robert Lu SSCrazy Points: 2428 More actions · Answer 13

Hi all,

Our system admin called microsoft, he was asked to

detach and reattach the database. It works. Is that easy?

Thanks!

Robert