Restore SQL 2008 backup file into SQL 2005

• cin_chow

  Grasshopper

  Points: 15

  More actions

  April 23, 2009 at 8:58 pm

  #155599

  Hi,

  I would like to know is there a way whereby i can restore a SQL 2008 backup database file into SQL 2005 server ?

  Is there any special command that we can use while backing up SQL 2008 database so that we able to restore the backup file into a SQL 2005 machine?

  the database in SQL 2008 is using compatibility level 10 - SQL Server 2008.

  Thanks in advance

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  April 23, 2009 at 9:10 pm

  #983361

  You can use the generate scripts wizard. Here is an article that describes how to do it.

  http://www.devx.com/dbzone/Article/40531

• Johan Bijnens

  SSC Guru

  Points: 135551

  More actions

  April 23, 2009 at 11:57 pm

  #983383

  You cannot do that using the regular backup / restore mechanisme.

  You can script the full database (tick sql2005 compatibility mode !) and then create it at a sql2005 instance, and then import the data using ssis.

  Johan
  
  Learn to play, play to learn !

  Dont drive faster than your guardian angel can fly ...
  but keeping both feet on the ground wont get you anywhere :w00t:

  - How to post Performance Problems
  - How to post data/code to get the best help[/url]

  - How to prevent a sore throat after hours of presenting ppt

  press F1 for solution, press shift+F1 for urgent solution 😀

  Need a bit of Powershell? How about this

  Who am I ? Sometimes this is me but most of the time this is me