Post reply

script

  • September 10, 2009 at 8:10 am

    #138699

    can any one send me the script likefinding dbname ,db owner,date created,size, space avaialble ,dboptions, no.of users, last backup, last diff backup, tran backup, maint.plans, space allocated by data and log file ?

    all variables in the same script,

    thanks

  • September 10, 2009 at 8:24 am

    #1051737

    ramyours2003 (9/10/2009)

    can any one send me the script likefinding dbname ,db owner,date created,size, space avaialble ,dboptions, no.of users, last backup, last diff backup, tran backup, maint.plans, space allocated by data and log file ?

    all variables in the same script,

    thanks

    I think you might be waiting a long time for someone to give you one script to do all that. there are scripts on this site that will do them separately.

    This is pretty basic stuff and not the first time you have asked for this. I would suggest that you search this site so you can learn how to do this, and then post for anything you need help with.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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