I am new to DB Admin in SQL Server.
I am more of a SQL Developer.
I am trying to restore 95GB size of BAK file to SQL Server (in Azure VM).
The issue is that it is taking more than 24 hours now..
I realized that since I have multiple more BAK files to restore after this one, I have to restore the main BAK file (95GB one) with "NoRecovery".
So, I went into a folder where 95GB Bak file is located, and selected the Recovery state as "Restore with Norecovery".
Then, I just started the process since yesterday, and it is taking more than 24 hours.
What am I doing wrong? Or is there anything else I need to do?
As far as % complete is concerned, it was completed (with 100%) after probably 2 hours from when the process was started. But it just shows as "Restoring..." after 24 hours, and I am not able to do any query or access.
Regards to other bak files, those should be like an hourly transaction log backup. Since the original data provider only provides in SQB files format, I have to convert them into BAK file using a third party app (RedGate's SQL Backup).