April 12, 2022 at 2:53 pm
I'm planning to carry out a rolling upgrade from a 2 node AG in SQL 2017 to a 2 node AG in SQL 2019. The 2017 backups are taken via URL to Azure Storage Accounts and these are then used to restore to the new 2019 servers. The backups are takenn using Ola Hallengrens scripts and have the @Verify flag set which pass. The restores to the new 2019 servers fail with a problem reading the backup blobs. I took new backups to rule out corrupt backups but had the same issue.
I run restore verifyonly on the 2019 server and it fails but I run the same command on the 2017 server and it succeeds.
I have now tried backing the db to a file rather than azure and this can be successfully restored to the 2019 server.
N.B. Other db's have been successfully restored from URL to the new 2019 server
Has anyone seen this issue before? is it an issue with 2019 CU15?
Thanks in advance
April 13, 2022 at 1:30 pm
Are the needed certificates installed on your SQL2019 ?
Easiest with DBATools Copy-DbaCredential
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 13, 2022 at 1:43 pm
Thanks for your reply,
It turns out that this issue is to do with the cluster service. If the cluster service is stopped then the restores work, if it's turned back on they fail.
We haven't proven whether this is to do with the different version of sql in the cluster (2017 and 2019) or whether it's the different versions of windows in the cluster as we are also moving to win 2022 from win 2019
Further testing to be done
April 13, 2022 at 1:48 pm
ah, another issue with Windows 2022 !!
( we have an issue with HyperV clustered on Win2022 ( bluescreens ) )
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
April 14, 2022 at 3:14 pm
Just for update, we have proven that a 2019 cluster works fine, only issue with Win 2022 cluster. Issue to be raised with Microsoft.
April 15, 2022 at 8:20 am
thank you for the feedback.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply