Error to attach database - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

Data Corruption Issues

Error to attach database

Author

Topic

wandy910
Starting Member

11 Posts

Posted - 2008-02-25 : 04:17:30

need some help with some errors.

Today I recieved this alert from the SQL Server, when I want to attach database:

Server: Msg 823, Level 24, State 6, Line 1
I/O error (torn page) detected during read at offset 0000000000000000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\DB Askes Apotik_Data.MDF'.

Connection Broken

I was Running dbcc checkdb repair_allow_data_loss with ALL_ERRORMSGS, NO_INFOMSGS yield the following:

Server: Msg 945, Level 14, State 2, Line 1
Database 'DB Askes Apotik' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.

Any ideas on how to resolve these errors?

thx

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-02-25 : 07:57:43

Check the error log for additional information . Confirm the location of the .mdf and .ndf files for the affected database and confirm that the account used by the Database Engine has permission to access those files.
You'll have to restart when the issue is sorted

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-25 : 13:58:43

Also check disk free space on d:\ drive.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-25 : 14:55:44

To be more precise, check free space for 'D:\Program Files\Microsoft SQL Server\MSSQL\data' directory, since SQL Server 2005 accepts mounting points.

E 12°55'05.25"
N 56°04'39.16"

wandy910
Starting Member

11 Posts

Posted - 2008-02-25 : 20:17:06

thx for all, i was check free space on harddisk (free space 60 GB, total HD 80 GB)

Any suggest?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-25 : 20:24:34

Is it in ntfs file system? Fat32 has 4gb file size limit.

wandy910
Starting Member

11 Posts

Posted - 2008-02-25 : 20:42:12

yes, NTFS file system.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-25 : 21:57:48

Then need to check windows event logs for disk related errors. Any details in sql server log?

wandy910
Starting Member

11 Posts

Posted - 2008-02-25 : 22:59:49

hi rmiao

i was check on SQL Server errorlog and than i have this error

Error: 5180, Severity: 22, State: 1
Could not open FCB for invalid file ID 0 in database 'DB Askes Apotik'.

what this error mean?

thx

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-25 : 23:22:00

What's your sql version and sp level?

wandy910
Starting Member

11 Posts

Posted - 2008-02-26 : 01:23:36

SQL server 2000.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-02-26 : 01:57:58

Usually this means the db isn corrupt or dropped out. Try the attach again and see if it happens again

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

wandy910
Starting Member

11 Posts

Posted - 2008-02-26 : 20:54:37

hi jackv

i was try to attach again, but i have same problem

Server: Msg 823, Level 24, State 6, Line 1
I/O error (torn page) detected during read at offset 0000000000000000 in file 'D:\Program Files\Microsoft SQL Server\MSSQL\data\DB Askes Apotik_Data.MDF'.

Connection Broken

help me please, i will greatful for your help.
thx

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-26 : 21:19:57

It was bug and fixed in sp1. Did you apply any sql2k sp?

wandy910
Starting Member

11 Posts

Posted - 2008-02-27 : 02:53:58