Restore an SQL 2008 full backup to SQL Serveer 2005

  •     selet the database in the Object Explorer in SQL 2008.
  •     right-click, select Tasks->Generate Scripts.
  •     In the options dialog emable about everything, including Script Data.
  •     And make sure you select “Script for SQL 2005”.

 

Leave a Reply