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 |
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] AJOIN 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] DESCCheersMIK |
|
|
vinay_555
Starting Member
10 Posts |
Posted - 2013-12-04 : 04:59:13
|
Thanks MIK... |
|
|
|
|
|