June 17, 2005 at 2:16 pm
I am getting this error when restoring a database.
---
The header for file 'd:\mssql\logs\mydb_log.ldf' is not a valid database file header. The FGID property is incorrect.
RESTORE could not start database 'mydb'.
RESTORE DATABASE is terminating abnormally.
Device activation error. The physical file name 'd:\mssql\logs\mydb_log.ldf' may be incorrect.
---
The MDF and LDF are were generated by the RESTORE, but when I try to attach, a similar error appears about the FGID property.
Any ideas as to a resolution? Thanks.
June 17, 2005 at 2:53 pm
Have you tried to run a RESTORE VERIFYONLY on the database file to verify integrity? You can find the syntax in BOL. IF that works, try dropping the database files, deleting the actual files, and rerunning the restores. If that works, you should probably check the integrity of the disks.
Derrick Leggett
Mean Old DBA
When life gives you a lemon, fire the DBA.
June 17, 2005 at 5:27 pm
What is the restore command that you are running? You should restore from the (typically) single file that is generated by the backup database/log commands. Do you have an .MDF and a .LDF file? If so, you just need to attach them.
You should also check if the path 'd:\mssql\logs\*' exists (ie, do you have a drive D: ?)
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply