Check which databases have been restored in last n number of days





DECLARE @dbname sysname, @days int

 SET @dbname = null --substitute for whatever database name you want, null will fetch for all the databases

 SET @days = -n --substitute n with previous number of days, script will default to 30

 SELECT
 rsh.destination_database_name AS [Database],
 rsh.user_name AS [Restored By],
 CASE WHEN rsh.restore_type = 'D' THEN 'Database'
  WHEN rsh.restore_type = 'F' THEN 'File'
  WHEN rsh.restore_type = 'G' THEN 'Filegroup'
  WHEN rsh.restore_type = 'I' THEN 'Differential'
  WHEN rsh.restore_type = 'L' THEN 'Log'
  WHEN rsh.restore_type = 'V' THEN 'Verifyonly'
  WHEN rsh.restore_type = 'R' THEN 'Revert'
  ELSE rsh.restore_type 
 END AS [Restore Type],
 rsh.restore_date AS [Restore Started],
 bmf.physical_device_name AS [Restored From], 
 rf.destination_phys_name AS [Restored To]

 FROM msdb.dbo.restorehistory rsh

 INNER JOIN msdb.dbo.backupset bs ON rsh.backup_set_id = bs.backup_set_id

 INNER JOIN msdb.dbo.restorefile rf ON rsh.restore_history_id = rf.restore_history_id

 INNER JOIN msdb.dbo.backupmediafamily bmf ON bmf.media_set_id = bs.media_set_id

 WHERE rsh.restore_date >= DATEADD(dd, ISNULL(@days, -30), GETDATE()) --want to search for previous days
AND destination_database_name = ISNULL(@dbname, destination_database_name) --if no dbname, then return all

 ORDER BY rsh.restore_history_id DESC
GO



Comments

Post a Comment

Popular posts from this blog

VS 2012: No exports were found that match the constraint : ContractName

Image
This morning, one of the fellow developers shared the issue. He was getting the error below while opening any of the files: And some other guys came up with the same thing. I tried to find the root cause, was unable to do so. I'll update this post if I find that. However, there is good news. I've got the solution: Resolution steps are ; -Close Visual Studio - Go to the location C:\Users\ navdeep \AppData\Local\Microsoft\VisualStudio\11.0 (replace navdeep with your user id) - Delete the folder ComponentModelCache. - Start Visual Studio It builds the component cache and the things are working again  :-)
Read more

How to Tweak the New Multi-Monitor Taskbar in Windows 8

Image
For years, users have wondered why on earth Microsoft wouldn’t make the taskbar customizable and usable across multiple monitors. The release of Windows 8 won’t tell us why it took so long, but at least we’ll get some new features. Here’s a quick look for those that haven’t already seen them. The new Taskbar in Windows 8 finally spans multiple monitors, and can be customized so that the taskbar buttons on each monitor are the buttons for windows open on that monitor. You can also make both taskbars show all windows if you choose. To access the new settings, head into Taskbar Properties by right-clicking on the Taskbar and choosing Properties. Once there, you’ll see the “Multiple displays” section at the bottom of the dialog, where you can quickly check the box to enable or disable showing the taskbar across displays. The “Show taskbar buttons on” drop-down lets you choose where the buttons appear. For example, the screenshot at the beginning of this article was from t...
Read more