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 - 2005-06-03 : 07:42:20
|
| jlbnet writes "sorry for my bad englishI have a database, which is created by sqlserver7. somedays before I upgraded it to sqlserver2000, and find something fault.Before upgrade I do have backuped the database. I attached that backuped db in sqlserver2000, and find nothing useful.Now I want to attach it in sqlserver7, but when i use sp_attach_db, it tells me:Server: Msg 5172, Level 16, State 15, Line 1The header for file 'E:\jlb\cardmanage_log.ldf' is not a valid database file header. The PageAudit property is incorrect.I use emergency mode two,but as i open a table, it tells me that version 539 is newer, can't openwhat can I do" |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-06-03 : 13:45:11
|
| Once you've attached it to SQL Server 2000, you can not use the same MDF to attach it to SQL Server 7.0. The file is not backwards compatible once it has been upgraded.Restore the database from your backup.Tara |
 |
|
|
|
|
|
database attached in sqlserver2000,can use in sqlserver7?