sql server查询备份进度

网上转载：http://blog.csdn.net/greenery/article/details/6532646

第一步，用 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