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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-06-17 : 15:31:21
|
| 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 present, but when I try to attach, a similar error appears about the FGID property.Any ideas as to a resolution?Thanks,RaySS2k |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-17 : 15:37:21
|
| When you ran the restore command, the MDF and LDF were already there? If so, copy them elsewhere as the restore command will create the files for you.Tara |
 |
|
|
rb1373
Yak Posting Veteran
93 Posts |
Posted - 2005-06-17 : 15:38:52
|
| No they weren't there. The restore operation put them there. The error message must have appeared at the very end was the database was being started. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-17 : 15:41:02
|
| It seems your database backup file is corrupt then. You'll need to try using an older full backup.Tara |
|
|
|
|
|
|
restore error (invalid file header)