Need a Query - SQL Server Forums

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.

All Forums

General SQL Server Forums

New to SQL Server Programming

Need a Query

Author

Topic

vinay_555
Starting Member

10 Posts

Posted - 2013-12-03 : 08:13:45

Hi guys,

I need a SQL query which lists out directory path from which the database has been restored recently ( i.e backup path ).....

Regards,
Vinay.

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2013-12-03 : 09:38:57

SELECT
A.[destination_database_name],
A.[restore_date],
C.[physical_device_name]
FROM msdb.[dbo].[restorehistory] A
JOIN msdb.[dbo].[backupset] B ON A.[backup_set_id] = B.[backup_set_id]
JOIN msdb.[dbo].[backupmediafamily] C ON B.[media_set_id] = C.[media_set_id]
WHERE destination_database_name = 'Halsoos_Restore'
ORDER BY A.[restore_date] DESC

Cheers
MIK

vinay_555
Starting Member

10 Posts

Posted - 2013-12-04 : 04:59:13

Thanks MIK...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources