Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

attach database from sql2008r2 to sql2008 Expand / Collapse
Author
Message
Posted Wednesday, December 18, 2013 3:59 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 8, 2014 1:48 AM
Points: 16, Visits: 45
hi
i dont english good and i will attach database form sql2008r2 to sql 2008 and problem for attach
plase help me
best regard
Post #1524018
Posted Wednesday, December 18, 2013 4:14 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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 2008, MVP
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

Post #1524022
Posted Wednesday, December 18, 2013 4:14 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:40 AM
Points: 2,480, Visits: 3,023
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’! **
Post #1524023
Posted Wednesday, December 18, 2013 5:50 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 8, 2014 1:48 AM
Points: 16, Visits: 45
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
Post #1524072
Posted Wednesday, December 18, 2013 6:02 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 1:14 PM
Points: 40,615, Visits: 37,081
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 2008, MVP
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

Post #1524077
Posted Wednesday, December 18, 2013 6:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 8, 2014 1:48 AM
Points: 16, Visits: 45
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
Post #1524094
Posted Wednesday, December 18, 2013 7:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 10:40 AM
Points: 2,480, Visits: 3,023
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’! **
Post #1524112
Posted Wednesday, December 18, 2013 10:02 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 8, 2014 1:48 AM
Points: 16, Visits: 45
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.
Post #1524217
Posted Wednesday, December 18, 2013 10:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Saturday, November 8, 2014 1:48 AM
Points: 16, Visits: 45
my problem solved.
very very thanks for your guide.
best regards.
Post #1524231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse