August 9, 2002 at 5:06 am
I tried to create a database in SQL Server 7 + SP3 starting from the instruction sp_attach_db and the following message error has come out: “The head of the file ‘D:\Databases\Prot_datos.mdf ' is not valid for a database. The property PageAudit is incorrect.” Does anybody have an idea of what this error means? Thank you in advance.
August 9, 2002 at 6:17 am
How did you detach the file? (Same server, other server, what version of SQL Server, ...)
Do you have any reason to be suspicious about file corruption? (E.g. disk crash)?
August 9, 2002 at 6:38 am
The problem is we didn’t detach the file cause we had to format the disk of our server. We installed the same version of SQL Server. We had a copy of our databases in a CD (mdf and ldf files) and we would like to create the databases from them. Then we used the instruction sp_attach_db but we had the error described before.
August 9, 2002 at 9:25 am
Silly thought, but sometimes silly things are overlooked: being that you copied your database from a CD, did your remove the "Read-Only" property from the Mdf and LDF files on the hard drive(s)?
August 9, 2002 at 9:46 am
Yes I did remove the "read-only" property.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply