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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-28 : 07:39:30
|
| luis writes "without aparent reason my sql2k server was not able to restart. I decided to reinstall it again. to my surprise when i tried to atatch the mdf file I got the following error:Error 5172 - . the header for file ogf_Log.ldf is not a valid database file header. The page audit +rpperty is incorrect. - 1 - is this possible to overcome?2 - how can i prevent my sql server to fail again.Thank you." |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-28 : 08:35:17
|
| You should have backups of all your databases.Try sp_attach_gle_file_db after renaming the log file.You can't stop the server failing because you are always at the mercy of hardware. You need to plan for failures.You can minimise failures by writing good code - i.e. that which minimises memory use, locking, transactions and uses simple constructs. Anything out of the ordinary is more likely to hit a bug.Make sure maintenance procedures are in place and backup/recovery procedures are tested.==========================================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. |
 |
|
|
|
|
|
corrupt sql log file