script needed urgently

• Nikhil-843675

  SSC Eights!

  Points: 945

  More actions

  February 9, 2009 at 4:59 am

  #93121

  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

• the__t

  Hall of Fame

  Points: 3260

  More actions

  February 9, 2009 at 5:48 am

  #940408

  This is a double-post. Please respond here:

  http://www.sqlservercentral.com/Forums/Topic652701-146-1.aspx

  "Got no time for the jibba jabba!"
  -B.A. Baracus