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.
| Author |
Topic |
|
underblau
Starting Member
2 Posts |
 Posted - 2002-08-09 : 06:21:06
|
| 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. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-09 : 06:42:06
|
| Means that you don't have a valid database file for the server you are trying to attach it to probably.Worthwhile checking the database before you detach it.==========================================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. |
 |
|
|
underblau
Starting Member
2 Posts |
Posted - 2002-08-09 : 10:55:57
|
| I explain the problem better now (sorry I'm not english)I have the mdf and ldf files (without detaching because of an accident with the server) from the database I would like to restore and I have a clean installation of the server and SQL 7. I tried to restore the database using the instruction sp_attach_db but the following message 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 know what can I do? Thank you in advance. |
|
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-09 : 11:04:07
|
| You can't attach a file that hasn't been detached.Why can't you detach it?Do you have a recent backup?Jay White{0}Edited by - Page47 on 08/09/2002 11:04:31 |
|
|
|
|
|
|
PageAudit is incorrect