Upgrade our CRM 2011 SQL server from 2008 R2 to SQL 2012

All replies

• 

  

  0

  Sign in to vote

  your safest option would be to create a new SQL server 2012 installation and then repoint your CRM to tho new instance.

  please see the following thread.

  https://community.dynamics.com/crm/f/117/t/120322.aspx

  regards

  Jithesh

  Saturday, February 21, 2015 9:32 AM
• 

  

  0

  Sign in to vote

  Thanks for the reply....I was wondering how to transfer the data from old crm DB server to the new one....when i backed up the DB from old sql server and try to restore it says the data you are trying to restore is different from the existing db. I rtied using with MOVE and still the same issue.

  -Red

  Sunday, February 22, 2015 4:24 AM
• 

  

  0

  Sign in to vote

  hi red,

  the process is to take a backup from 2008 database, restore as new database on to the target 2012 server.

  regards

  Jithesh

  Sunday, February 22, 2015 5:04 AM
• 

  

  0

  Sign in to vote

  please see if this helps.

  https://social.technet.microsoft.com/Forums/sqlserver/zh-CN/e614c52c-fbd7-4877-8e26-03d4d58f61ed/how-to-restore-sql-server-2008-r2-databases-on-sql-server-2012?forum=sqlsetupandupgrade

  regards

  Jithesh

  Sunday, February 22, 2015 9:06 AM
• 

  

  0

  Sign in to vote

  On this site they explain how to copy an existing (CRM) database to another: http://survivingcrm.com/2012/08/creating-a-copy-of-your-production-crm-database/

  Monday, February 23, 2015 3:11 PM
• 

  

  0

  Sign in to vote

  Thanks Jithesh,

  I will try these steps and let you know the results.

  -Red

  Monday, February 23, 2015 4:20 PM
• 

  

  0

  Sign in to vote

  Hi Jithesh,

  I get the same error message every time....

  The backup set holds a backup of a database other than the existing 'XXXXXXXX_MSCRM' database.
  Msg 3013, Level 16, State 1, Line 2
  RESTORE DATABASE is terminating abnormally.

  Our network team is setting up our new domain and the new servers are on that domain..is that the reason for this do you think?

  -Red

  Monday, February 23, 2015 6:36 PM
• 

  

  0

  Sign in to vote

  To avoid the 'The backup set holds a backup of a database other than the existing...' message, use the WITH REPLACE clause (if using T-SQL), or 'Overwrite Existing Database' (if using SSMS). If you still get this message, make sure you're restore a full database backup, and not a partial backup.

  You mention a new domain. That won't affect the SQL restore, but it will affect CRM, as the CRM and SQL servers need to be in the same domain as each other

  ---

  Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

  Tuesday, February 24, 2015 10:27 AM

  Moderator
• 

  

  0

  Sign in to vote

  Thanks Guys, I used With REPLACE and was getting the same error.

  But instead of restore data for existing database I restored files and filegroups and let it create the new DB.

  Databases > Restore Files and Filegroups > Browse to the location of .bak file > Name the DB in "To database" filed and let it run.

  thanks for all the help.

  • Marked as answer by ColourRed Wednesday, February 25, 2015 10:59 PM

  Wednesday, February 25, 2015 10:58 PM