SQL SERVER还原数据库并查看进度脚本

–还原数据，相关参数可以查询ms官网介绍。太多了，不做重复介绍

USE [master]
RESTORE DATABASE [IMSDB]  FROM  DISK = N'D:\IMSDB_backup_2018_11_11_000011_1600388.bak' with recovery, FILE = 1,
  MOVE N'IMSDB' TO N'G:\dbData\IMSDB.mdf',  MOVE N'IMSDB2' TO N'G:\dbData\IMSDB2.ndf',
   MOVE N'IMSDB_log' TO N'G:\dbData\IMSDB_log.LDF',  NOUNLOAD ,REPLACE , 
   STATS = 10

GO


 --WITH  FILE = 1,

查看进度的脚本

--查看进度
SELECT DB_NAME(er.[database_id]) [DatabaseName],er.[session_id] AS [SessionID],er.[command] AS [CommandType]
,est.[text] [StatementText],er.[status] AS [Status],CONVERT(DECIMAL(5, 2), er.[percent_complete]) AS [Complete_Percent],
CONVERT(DECIMAL(38, 2), er.[total_elapsed_time] / 60000.00) AS [ElapsedTime_m],CONVERT(DECIMAL(38, 2),
 er.[estimated_completion_time] / 60000.00) AS [EstimatedCompletionTime_m],er.[last_wait_type] [LastWait],
 er.[wait_resource] [CurrentWait]
 FROM sys.dm_exec_requests AS er 
 INNER JOIN sys.dm_exec_sessions AS es ON er.[session_id] = es.[session_id]
 CROSS APPLY sys.dm_exec_sql_text(er.[sql_handle]) est
 WHERE er.[command] = 'RESTORE DATABASE'
 */

 /*
 SELECT
session_id, request_id, start_time, status, command
, percent_complete, estimated_completion_time,wait_time, cpu_time, total_elapsed_time, scheduler_id
,sql_handle
,statement_start_offset, statement_end_offset, plan_handle
, database_id, user_id --,connection_id
, blocking_session_id
, wait_type, last_wait_type, wait_resource, open_transaction_count, open_resultset_count, transaction_id
, context_info
, 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=52