Post reply

Script needed urgently

  • 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

  • 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

  • February 9, 2009 at 5:19 am

    #940395

    hey thanks a lotttttttt yar..

    i was searching for long for such kind of system table

  • February 9, 2009 at 5:20 am

    #940396

    Does this Logs remote locations also??

  • 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

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

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