I am the admin and i have not touched that database but all of a sudden it shows like someone is restoring it since long
我是管理员，我没有碰过那个数据库，但突然它显示好像有人正在恢复它很长时间
3 个解决方案
#1
2
Try running EXECUTE sp_who2 to identify the process that is running the restore. That row will also display who is doing it and from which machine.
尝试运行执行sp_who2来识别正在运行恢复的进程。这一行还将显示谁在做这件事，以及从哪台机器。
#2
2
Try this...
试试这个…
SELECT [USER_NAME]
,restore_date
,destination_database_name
FROM msdb..restorehistory
WHERE destination_database_name = 'DB_Name' --<-- Your Database name
#3
1
It's too late for you, but I'd use something like this:
对你来说太晚了，但我会用这样的东西:
select s.original_login_name
from sys.dm_exec_requests as r
join sys.dm_exec_sessions as s
on r.session_id = s.session_id
where r.command = 'RESTORE'
#1
2
Try running EXECUTE sp_who2 to identify the process that is running the restore. That row will also display who is doing it and from which machine.
尝试运行执行sp_who2来识别正在运行恢复的进程。这一行还将显示谁在做这件事，以及从哪台机器。
#2
2
Try this...
试试这个…
SELECT [USER_NAME]
,restore_date
,destination_database_name
FROM msdb..restorehistory
WHERE destination_database_name = 'DB_Name' --<-- Your Database name
#3
1
It's too late for you, but I'd use something like this:
对你来说太晚了，但我会用这样的东西:
select s.original_login_name
from sys.dm_exec_requests as r
join sys.dm_exec_sessions as s
on r.session_id = s.session_id
where r.command = 'RESTORE'