Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2003-05-02 : 11:29:29
|
Is there a system table that keep tracking of restored DB records?something like:select * from (system_table)where restoreDB_date > Dateadd( dd, -1, getdate) Jung |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-05-02 : 12:38:56
|
| How about this system table: msdb.dbo.restorehistory? Anytime that I want to find a particular system table or maybe a system stored procedure that does what I want, I always search in both the master database and the msdb database. Just keep in mind that when you query against the system objects directly that you might not be able to do it the same way in the next version, so most people would suggest to not code against them. But I find that coding against the system objects for information purposes is quite handy sometimes as long as you don't use it in production code or anything similar.HTH,Tara |
 |
|
|
|
|
|
Restore DB and system table