I/O Error while attaching database

[rrowland]

I am trying to attach a .mdf SQL Database file to an new SQL server. I receive the following error.

I/O error (bad page ID) detected during read at offset 0x00000000030000 in file <filename>

Can anyone tell me if there is a utility that I can run to fix this problem?

Thanks,

Richard

 

[nigelrivett]

Not easily. Always best to use backup restore for this sort of thing as it's more reliable and you still have the source database if the mdf isn't attachable.

Try it on the source server to see if it's a problem with the destination.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[rrowland]

That is the problem...

Our SQL Server crashed and the data was corrupt.. No one put this patricular database in the maintenance plan so there are no backups.

 

[nigelrivett]

I don't advise using the maint exe either.

You can contact microsoft support services

http://support.microsoft.com/default.aspx?scid=fh;EN-US;CNTACTMS

Or there are other products

http://www.officerecovery.com/mssql/

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.