October 29, 2012 at 5:22 pm
I'm having trouble moving my 2010 db's to 2012. The first thing I tried was just a "restore" from 2012 and pointing at the 2010 backup directory. 2012 would not show me the backup files in the 2010 backup directory. Then I tried manually copying one of the .bak's from the 2010 backup directory to the 2012 backup directory. This time 2012 showed me the backup and allowed me to restore it, but none of the user objects appeared in the restored database.
What is the recommended way to migrate 2010 db's to 2012?
Thanks!
.
October 29, 2012 at 7:40 pm
I've not had any issues like this, and I've used backup and restore multiple times. Recommended migration is typically backup and restore, or detach and attach, or in place upgrade. They should all work providrd the source database isn't the problem.
Have you checked the original compatibility mode of the source database? If it's not 90 or 100 you could have problems as SQL Server 2000 (80) can't be directly upgraded to SQL 2012.
Cheers
Leo
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
October 30, 2012 at 4:20 am
There's a 2010 version of SQL Server?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 4:48 am
The more common name is sql2008r2. Either that or he's confusing SharePoint and SQL.
October 30, 2012 at 6:02 am
foxxo (10/30/2012)
The more common name is sql2008r2. Either that or he's confusing SharePoint and SQL.
If it is 2008R2, I never had any issue migrating them. Just did a backup and restore.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 30, 2012 at 10:01 am
Quite right Crazy8! Getting my Visual Studios & SQLs all mixed up, which should not surprise you since Microsoft seems to be doing the same thing! Have you seen SSDT. 🙂
.
October 30, 2012 at 11:27 am
I think I figured out the problem. I was using the SQL 2012 SSMS to do the restore. On this version, the Restore Dialog has a new "Files" option on the left in the "select a page" section. By default, my restore was restoring the db back to my 2008R2 server data directory. I suppose it pulled that path out of the backup when I opened it, so I had to check the "Relocate all files to folder" option and override the folder and restore to the right place. I could be wrong, but I don't think this step would have been necessary using 2008R2 SSMS. I think it would have picked the right destination folder by default.
Anyway, if someone else has a similar problem, be sure that the db is being resoted to the correct folder.
.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply