SQL Server 2019 Database Restore Hang

Question

Hi, I'm using SQL Server 2019 instance and if I try to restore database with less number of stripes then backup, it will hang like waiting for server. However I did not face this issue with any of the other SQL versions.

E.G So I tried to take backup with 5 no of stripes and then try to restore with 3 stripes. However the same scenario will work on SQL14/16/17 without facing any issue.

I did not understand what could be the issue with 2019 version any lead on this really appreciated.

Answer 1

Hi @Ravi Parikh ,

Because your command line seem from IBM, It is recommended to ask for help in IBM Support forum
From this forum, I notice an article, it says that if less stripes are used for restore than for backup, SQL restore will fail
https://www.ibm.com/support/pages/apar/IT37582

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

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

with less number of stripes then backup

What?
That's to less on information, please post much more details about what you do and if you get an error message, also the complete error text.