SQL compatibility Help

All replies

• 

  

  0

  Sign in to vote

  Do you mean a database backup?

  SQL 2019 will work with a database in SQL Server 2008 compatability.

  • Proposed as answer by Amelia GuMicrosoft contingent staff Friday, August 14, 2020 3:21 AM

  Thursday, August 13, 2020 2:17 PM
• 

  

  0

  Sign in to vote

  Did a quick Google Search and MS doc explicitly states:

  Backup and restore: A backup taken on SQL Server 2008 or SQL Server 2008 R2 can be restored to SQL Server 2019.

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

  https://docs.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15

  So, you should be fine using the latest and the greatest version of SQL Server (and will have a chance to test MS Doc).

  ---

  Looking for new opportunities

  For every expert, there is an equal and opposite expert. - Becker's Law

  
  My blog
  
  My TechNet articles

  • Proposed as answer by Amelia GuMicrosoft contingent staff Friday, August 14, 2020 3:21 AM

  Thursday, August 13, 2020 2:23 PM
• 

  

  0

  Sign in to vote

  Thank you that is great. Lets hope it works. Kind Regards

  Thursday, August 13, 2020 2:33 PM
• 

  

  0

  Sign in to vote

  Thank you so much. Really appreciate the update

  Thursday, August 13, 2020 2:34 PM
• 

  

  0

  Sign in to vote

  Hi DMV_1,

  Did you resolve your issue?

  If you have resolved your issue, please mark the useful replies as answer. This can be beneficial to other community members who have similar questions.

  Best Regards,

  Amelia

  ---

  ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
  We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
  For more information, please refer to the sticky post.

  Friday, August 14, 2020 3:21 AM