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