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 |
|
juggler
Starting Member
9 Posts |
 Posted - 2008-03-31 : 14:14:57
|
| I inherited some very old sql server backup files, but I don't know which sql server version was used to create them.They are either sql 6.5, 7.0, or 2000 (none of which I currently have installed).When I do RESTORE FILELISTONLY in sql 2005, I get this error:The media family on device 'c:\oldfile.dat' is incorrectly formed. SQL Server cannot process this media family.I would like to know which version of sql server I need to install so I can access the data in these old backup files.Does anyone know how to identify which version of sql server was used to create a particular backup file? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-31 : 14:26:23
|
| SQL server 6.5 Backup files has (.DAT extension).If it was backup in SQL 7.0 then you should be able to restore in SQL 2000.But if you backup in SQL 2000,You can't restore in 7.0 (as a matter of fact you are not using in SQL 7.0). Try restoring it in SQL 2000. |
 |
|
|
|
|
|
how to identify version of sql backup file