September 24, 2012 at 11:12 am
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?
September 24, 2012 at 11:15 am
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.
September 24, 2012 at 11:29 am
Can I use the Copy Database wizard?
September 24, 2012 at 11:41 am
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.
September 24, 2012 at 12:11 pm
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" 😉
September 25, 2012 at 6:27 am
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
September 25, 2012 at 6:29 am
You can only exprot the data and use.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply