Execute the sys.dm_exec_requests DMV in SQL Server Management Studio to get the status of the backup or restore operations.