attach database from sql2008r2 to sql2008

  • hi

    i dont english good and i will attach database form sql2008r2 to sql 2008 and problem for attach

    plase help me

    best regard

  • Can't be done.

    A SQL 2008 R2 database can only attach to SQL 2008 R2 or SQL 2012. SQL Server does not allow downgrading of database versions

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • It is not possible to detach/attach a database from a higher version (SQL2008 R2) to a previous version (SQL 2008). You also can not restore a backup to a previous version.

    The only way to transfer the data is to script-out the definition and to import all the data.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • very thanks for all helps.

    i create script from database file but in another system with sql2008 not run and error

    how to script and run script in sql2008.

    best regard

  • Right click database -> tasks -> generate scripts.

    Don't script the data, use import/export once you've created the database on SQL 2008.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • very thank for guide my problem

    i have a database with table ,procedure,trigger,view with sql2008r2 in a one system

    and i will transfer data a another system with sql 2008

    i have n't export from database.

    database/task/export/.

    i can not export store procedure from database.

    please help me

    best regard

  • fateme.soleimani67 (12/18/2013)


    very thanks for all helps.

    i create script from database file but in another system with sql2008 not run and error

    how to script and run script in sql2008.

    best regard

    Make sure you first set the option in SSMS to create SQL2008 scripts:

    - in SSMS go to menu "Tools"

    - select menu-option "Options"

    - navigate to and expand "SQL Server Object Explorer"

    - Click on "Scripting"

    - select "SQL 2008 Server" as option for item "Script for server version"

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
  • i create script and copy and paste in another system and open file scrip and click run but i face error:

    database doesn't exist .

    i set sqlserver2008r2 in script for server version.

    please help me

    best regards.

  • my problem solved.

    very very thanks for your guide.

    best regards.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply