Script needed urgently

• Nikhil-843675

  SSC Eights!

  Points: 945

  More actions

  February 9, 2009 at 4:58 am

  #127938

  Can Any1 Provide Scripts to get following details for all databases on server.

  databasename,mdf filelocation,ldf filelocation,local_backuplocation,remotebackup_location.

  Both local and remote backup maintenance plans are present on server.

  Please help in getting backup locations,other details i can get,if one can give entire then well and good but atleast backuplocations are needed...PLZ do needful

  thanks and regards,

  Nikhil

• Sriram-288748

  SSCrazy

  Points: 2874

  More actions

  February 9, 2009 at 5:12 am

  #940394

  hello,

  you can get the required information from two tables one from sysfiles and the other from dbo.backupmediafamily in msdb.

  Sriram

• Nikhil-843675

  SSC Eights!

  Points: 945

  More actions

  February 9, 2009 at 5:19 am

  #940395

  hey thanks a lotttttttt yar..

  i was searching for long for such kind of system table

• Nikhil-843675

  SSC Eights!

  Points: 945

  More actions

  February 9, 2009 at 5:20 am

  #940396

  Does this Logs remote locations also??

• Tim Wilson-Brown

  Ten Centuries

  Points: 1395

  More actions

  February 10, 2009 at 3:26 pm

  #941714

  This is a double (actually quadruple) post.

  Please respond here http://www.sqlservercentral.com/Forums/Topic652704-338-1.aspx