如果我想在表格中获取有关恢复的信息怎么办? [英] What if i want to get the info about restoration in a table ?
问题描述
如果我想在表格中获取有关恢复的信息怎么办?
What if i want to get the info about restoration in a table ?
我创建了一个表,从上面的SP获取用户名,id,数据时间的数据,现在我想得到数据库恢复或n恢复了。尝试使用IF条件的所有可能方式,但我无法做到。
I have created a table which get data of username,id,datatime from the above SP and now i want to get the data of db restored or not restored. Tried all possible ways using IF condition but am not able to.
任何人都可以帮我吗?
Can anyone help me on this ?
谢谢,
推荐答案
嗨Surya411,
Hi Surya411,
感谢您的发帖。
在您提供的链接中,它会自动恢复特定的数据库。\\ n \\ n字体大小:11.0pt">您想要哪些信息?据我所知,数据库在上次日志恢复之前不可用。因此您无法检查表是否已恢复。您是否要检查数据库的
情况?
Which information would you like ? Could you please share us your expected result ? In the link which you provided, it will restore specific database automatically. As I know, the database is not available until the last log restore. So you can't check if the table is restored. Would you like you check the situation of database ?
在下面的脚本中,您将看到数据库的情况。
In following script, you will see the situation of the database.
select name,state,state_desc from sys.databases
有关sys.databases的更多信息,请参考:
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog -views / sys-databases-transact-sql?view = sql-server-2017
For more information about sys.databases, please refer to it: https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-databases-transact-sql?view=sql-server-2017
有一篇关于
的文章
如何监控SQL Server中的备份和恢复进度,请参考。
希望它可以帮到你。
最好的问候,
Rachel
这篇关于如果我想在表格中获取有关恢复的信息怎么办?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!