Share via

SQL Server 2019 Database Restore Hang

Ravi Parikh 21 Reputation points
2022-06-30T10:50:23.973+00:00

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.

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

Answer accepted by question author

YufeiShao-msft 7,156 Reputation points
2022-07-01T07:51:22.627+00:00

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.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,621 Reputation points
    2022-06-30T11:38:06.167+00:00

    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.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.