Look, there’s an issue that’s dogged it since 2012 IIRC. I’m still getting it in 2019.
It’s when you try to restore a pretty large DB BAK file, like over a GB compressed. You hit restore and then that green bar next to ‘stop’ just sits there animating but you never see the percentage restored amount appear.
The only way out is to hit the stop button, delete the ‘restoring’ entry in the DB table and do it all over again and this time:
I wouldn’t know because I never use the command line. But it did cross my mind that it might somehow be a SSMS fault, yeah. That said SSMS has gone through even more versions since 2012 than SQL Server itself.
I use it a fair bit but not for that kind of thing. I’ll ask the SQL genius in work if she knows anything about it tomorrow though if you don’t get an answer
Asked and she said to see if your log file can give you any more data. In management/SQL server logs. Other than that apart from checking for updates she didn’t have an answer but said she hasn’t seen it before.
install sp_whoisactive ( sp_whoisactive SQL Server Monitoring Stored Procedure by Adam Machanic). this’ll show whats running on the instance. theres a column in the output called percent_complete which could help. my guess is that you’ve got a huge transaction log file which needs to be zeroed out which probably takes a while and the percent increment wont start until its done.
