SQL Server database migration

[Yukinobu]

Hi,

Our customer is planning to restore a SQL Server failover cluster instance database using SQL Server 2008SP4 to an AlwaysOn Availability Group contained database using SQL Server 2019 and vice versa.

Can we make that using Veeam Agent for Windows(managed by VBR) and Veeam Explorer for SQL Server?

[HannesK]

Hello,
yes, cross-version restore for migration is a common thing. Veeam customers do that since many years.

Best regards,
Hannes

[Yukinobu]

Hi,

Thank you for info.
Contained database was added option in SQL Server 2012.
https://docs.microsoft.com/en-us/sql/re ... rver-ver15

Is not affect to restore to 2008SP4?

Kind Regards,
Yukinobu Asami

[HannesK]

Hello,
actually I never heard of that feature.

I also just read the "vice versa": from old to new I expect it to work. If not, please post the support case number.

I expect issues if you try to restore 2019 to 2008. But that's just like with every software. Migration from old to new works. From new to old often fails.

Can you explain why anyone would do a restore from new to old? That makes no sense to me.


Thanks,
Hannes