Post reply

How to find location of backup files

  • May 22, 2011 at 12:01 am

    #251335

    Hi,

    If someone has backed up the databases and placed the backup files to location other than predefined location, how can I know the location of backup files.

    Thanks in advance.

  • May 22, 2011 at 1:49 am

    #1328163

    beejug1983 (5/22/2011)

    Hi,

    If someone has backed up the databases and placed the backup files to location other than predefined location, how can I know the location of backup files.

    Thanks in advance.

    Try this

    select b.database_name,a.physical_device_name from msdb.dbo.backupmediafamily a

    join msdb.dbo.backupset b

    on (a.media_set_id=b.media_set_id)

    where database_name='test'

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • May 22, 2011 at 2:50 am

    #1328164

    Muthukkumaran, thanks for your prompt reply, it really helped me. 🙂

  • May 22, 2011 at 3:13 am

    #1328166

    beejug1983 (5/22/2011)

    Muthukkumaran, thanks for your prompt reply, it really helped me. 🙂

    Glad to help you.Your welcome.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply