Post reply

Automatically take a Transaction log backup in SQL SERVER.

  • September 13, 2011 at 7:39 am

    #243149

    Hello All,

    I am in the process of creating a Alert for the Transaction Log Full error.

    i have already setup the alert and it will send a email to the DBA team in case if the alert fires up.

    I need help in creating a job that automatically kicks in in this alert fires up.

    I am looking for a script that basically run on the server, scan the database names from the sys table and if in particular database log file is full , take a log back for this database.

    Can any one give me an insight for this.

    Thanks in advance.

  • September 13, 2011 at 7:45 am

    #1380631

    Still not a good idea.

    Don't cross-post it just waste everybody's time

    Conitnue the thread here. http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

  • September 13, 2011 at 7:45 am

    #1380632

    Duplicate thread.

    Looks like Gail already answered this for you here:

    http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

    Edit, beaten by a few seconds :hehe:

  • September 13, 2011 at 7:46 am

    #1380635

    homebrew01 (9/13/2011)

    Duplicate thread.

    Looks like Gail already answered this for you here:

    http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

    And Ninja wins it again by half a nose :-D.

  • September 13, 2011 at 7:48 am

    #1380637

    homebrew01 (9/13/2011)

    Duplicate thread.

    Looks like Gail already answered this for you here:

    http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

    Edit, beaten by a few seconds :hehe:

    And I also beat the edit by a few seconds :hehe:.

  • September 13, 2011 at 7:48 am

    #1380638

    Ninja's_RGR'us (9/13/2011)

    homebrew01 (9/13/2011)

    Duplicate thread.

    Looks like Gail already answered this for you here:

    http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

    And Ninja wins it again by half a nose :-D.

    Curse you Ninja !!:-P

  • September 13, 2011 at 7:51 am

    #1380642

    homebrew01 (9/13/2011)

    Ninja's_RGR'us (9/13/2011)

    homebrew01 (9/13/2011)

    Duplicate thread.

    Looks like Gail already answered this for you here:

    http://www.sqlservercentral.com/Forums/Topic1173742-357-1.aspx

    And Ninja wins it again by half a nose :-D.

    Curse you Ninja !!:-P

    And too late for a 3rd time :-P.

  • September 13, 2011 at 8:26 am

    #1380691

    Obviously my answer was deemed so unacceptably stupid that it didn't even warrant a reply... :hehe:

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 13, 2011 at 8:28 am

    #1380695

    GilaMonster (9/13/2011)

    Obviously my answer was deemed so unacceptably stupid that it didn't even warrant a reply... :hehe:

    Of course not, what the hell do you know about DR? :Whistling:

  • September 13, 2011 at 8:32 am

    #1380699

    Ninja's_RGR'us (9/13/2011)

    GilaMonster (9/13/2011)

    Obviously my answer was deemed so unacceptably stupid that it didn't even warrant a reply... :hehe:

    Of course not, what the hell do you know about DR? :Whistling:

    Clearly not much. Now, if you'll excuse me, I'll be off replacing my failed drive and restoring my backups.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 13, 2011 at 8:34 am

    #1380701

    GilaMonster (9/13/2011)

    Ninja's_RGR'us (9/13/2011)

    GilaMonster (9/13/2011)

    Obviously my answer was deemed so unacceptably stupid that it didn't even warrant a reply... :hehe:

    Of course not, what the hell do you know about DR? :Whistling:

    Clearly not much. Now, if you'll excuse me, I'll be off replacing my failed drive and restoring my backups.

    At your bank clients or home pc :-P?

  • September 13, 2011 at 8:38 am

    #1380711

    Home PC. My clients know better (usually because I teach them, sometimes cause they learn the hard way first)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • September 13, 2011 at 8:43 am

    #1380716

    GilaMonster (9/13/2011)

    Home PC. My clients know better (usually because I teach them, sometimes cause they learn the hard way first)

    Doesn't the latter lead to the former most of the time? 😀

  • September 13, 2011 at 8:49 am

    #1380721

    Ninja's_RGR'us (9/13/2011)

    GilaMonster (9/13/2011)

    Home PC. My clients know better (usually because I teach them, sometimes cause they learn the hard way first)

    Doesn't the latter lead to the former most of the time? 😀

    Yup. 😀

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 14 posts - 1 through 13 (of 13 total)

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