sqlcmd not showing RESTORE database stats

Question

The following command in a cmd window

sqlcmd -S. -Usa -Ppass -dmaster -Q "RESTORE DATABASE [MYDATABASE] FROM DISK = 'D:\SQL Server\MYDATABASE.BAK' WITH FILE = 1, NOUNLOAD, REPLACE, STATS = 10"

displays the following progress output:

10 percent processed.
20 percent processed.
30 percent processed.
40 percent processed.
50 percent processed.
60 percent processed.
70 percent processed.
80 percent processed.
90 percent processed.
100 percent processed.
Processed 32320 pages for database 'MYDATABASE', file 'MYDATABASE' on file 1.
Processed 7 pages for database 'MYDATABASE', file 'MYDATABASE_log' on file 1.

But it turns that the progress is shown only after the entire restore, turning the stats during the process useless.

Any advice?

Here is the version of sqlcmd tool:

Microsoft (R) SQL Server Command Line Tool
Version 12.0.2000.8 NT
Copyright (c) 2014 Microsoft. All rights reserved.

Update Dec-2016:

Just including the comment from Microsoft Connect link shared in comments:

SQLCMD was rewritten in SQL 2012 to use ODBC. Here is a small regression error that appears to have sneaked in.

It's the same effect reported when calling RAISERROR('Hello', 0, 1) WITH NOWAIT along a script.

Answer 1

You can query percent_complete in sys.dm_exec_requests.

Open a separate SQL window and issue the following command

select percent_complete from sys.dm_exec_requests where percent_complete > 0