hmm. I recently did a clean install of Windows 7, and that was a nice opportunity to get of rid of all redundant software.
So I only installed Sql 2008 because it must be backwards compatible. I thought: I can open a Sql 2005 database in
Sql 2008 Management Studio, create a backup (unedited), and restore it again in Sql 2005.
The backup formats differ in 2005 and 2008, which makes perfectly sense. But I’m not using any of the new types, and the structure
remained the same, so I assumed … I was wrong! [assumptions are the mother of all ***]
Afaik, there’s no option like “Save as sql 2005”. So I generated a script with “script data=true” and “Script for SQL 2005”.
…Installing Sql 2005….