第一步,用 sp_who2 查出备份还原的sid(或在窗口中的连接属性中看)
第二步,用以下查询获得运行情况(看 percent_complete列)
SELECT
session_id, request_id,
start_time, status, command, sql_handle
--,statement_start_offset,
statement_end_offset, plan_handle
, database_id, user_id
--,connection_id
, blocking_session_id
, wait_type, wait_time,
last_wait_type, wait_resource, open_transaction_count, open_resultset_count,
transaction_id
--, context_info
, percent_complete,
estimated_completion_time, cpu_time, total_elapsed_time, scheduler_id
--,
task_address
, reads, writes, logical_reads
--, text_size, language,
date_format, date_first, quoted_identifier, arithabort, ansi_null_dflt_on,
ansi_defaults, ansi_warnings, ansi_padding, ansi_nulls, concat_null_yields_null,
transaction_isolation_level, lock_timeout, deadlock_priority, row_count,
prev_error, nest_level, granted_query_memory, executing_managed_code, group_id,
query_hash, query_plan_hash
FROM sys.dm_exec_requests WHERE
session_id=54
or session_id=57