我想知道数据库还原了哪个主机（客户端IP地址）？ [英] I want to know from which Host(client IP address) the database was restored?

问题描述

今天，其中一名员工恢复了数据库。我想知道谁恢复了db。 

使用下面的查询我可以获取时间，但是我;我无法获得主机或IP地址，你能建议吗？ / p>

从msdb.dbo.restorehistory中选择*其中destination_database_name ='Dev'顺序由restore_date desc

解决方案

你不能，SQL Server不存储主机/ IP地址，你只能从restorehistory获得用户名。

Today one of the employees restored the db. I want to know who restored db. 

using the below query I can fetch the time, However I;m not able to get the host or IP address, can you suggest?

select * from msdb.dbo.restorehistory where destination_database_name='Dev' order by restore_date desc

解决方案

You can not, SQL Server don't store host/IP addresse, you can get only the user Name from restorehistory.

这篇关于我想知道数据库还原了哪个主机（客户端IP地址）？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！