SQL Server 2019

calicyclist

I see in the requirements for Red-Gate that the newest version listed is 2017.  However, I see in the release notes for 10.0 that it says "Backups created using SQL Server 2017-2019 can now be restored using Object Level Recovery (though many new features such as native compression and encryption remain unsupported)"

So what is it?  Does RG support backup and recovery of SQL 2019 or not?

Alex B

Hi all,

And I've now amended the documentation to include SQL Server 2019 here https://documentation.red-gate.com/sbu10/getting-started/requirements 

Kind regards,
Alex

Alex B

Hi @calicyclist ,

For what it's worth, I've just tried a backup and restore of a simple database in SQL Server 2019 and it has worked.

I'll double check with the team to see why it may not be on the requirements page yet - it could have been missed or possibly there is some requirement for it to be included that I'm not aware of.

I'll update further when I have more information.

Kind regards,
Alex

Alex B

Hi @calicyclist,

I've checked with the team and it seems to be a documentation oversight as there is a suite of tests running against SQL Server 2019.

I'll work with them to get that updated, but you are good to go using SQL Backup against SQL Server 2019.

Kind regards,
Alex

calicyclist

Great.  Thanks for your help!

baghul

I have a related question.

We are running RG SQL backup 9.2
REcently we upgraded some sql boxes to sql 2019. However we are having challenges with running Redgate sql backups now.

Seem to be getting error # 605

My questions is
Does SQL backup 9.2 support Full backups of SQL Server 2019 or do I need to upgrade RG to newer version?
Thanks!

Alex B

Hi @baghul,

SQL Backup 9.2 doesn't support SQL 2019 (this is the page for what it does support  ).

Support for SQL 2019 was added in 10.0.2 (release notes).

Kind regards,
Alex