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

Move DB from 2008R2 Enterprise to 2008 Standard Expand / Collapse
Author
Message
Posted Monday, September 24, 2012 11:12 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 2:32 PM
Points: 22, Visits: 102
I am moving a database via backup/restore from a 2008r2 Enterprise server to a 2008 Standard server. Since it is kind of a downgrade of versions, is there anything special I need to run after the restore is completed?
Post #1363639
Posted Monday, September 24, 2012 11:15 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:03 PM
Points: 23,045, Visits: 31,569
If you are going from 2008 R2 to 2008, you won't be able to use the backup/restore. You will need to script your database on SQL Server 2008 R2, and create an empty database in 2008. Then use SSIS to transfer the data from 2008 R2 to 2008.


Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1363640
Posted Monday, September 24, 2012 11:29 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 28, 2014 2:32 PM
Points: 22, Visits: 102
Can I use the Copy Database wizard?
Post #1363649
Posted Monday, September 24, 2012 11:41 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 8:03 PM
Points: 23,045, Visits: 31,569
mcopa (9/24/2012)
Can I use the Copy Database wizard?



Probably. I have had issues using it myself, so I tend to script the database then use SSIS to transfer data.



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #1363656
Posted Monday, September 24, 2012 12:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:15 AM
Points: 6,182, Visits: 13,329
mcopa (9/24/2012)
Can I use the Copy Database wizard?

if you use the detach\attach method no you can't.
If you use the object method trnasfer it might work as it reads the objects and then recreates them and then copies data


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1363670
Posted Tuesday, September 25, 2012 6:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 11:29 PM
Points: 459, Visits: 1,889
Script out objects as Lynn suggested and use SSIS to import the data. Else you can also go for the replication option to minimize the downtime.

Thanks
Chandan
Post #1363979
Posted Tuesday, September 25, 2012 6:29 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, September 30, 2013 2:09 AM
Points: 3,131, Visits: 1,058
You can only exprot the data and use.




Post #1363983
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse