Forum Replies Created

Viewing 15 posts - 24,751 through 24,765 (of 49,552 total)

  • RE: Backup of TX Log: Failed:(-1073548784)

    Warren Peace (7/21/2011)

    In the pleasant scenario you give there's a chance (it happened more than once) that the one, or many, TX log files bloat and ALL the DB's stop...

    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

    July 21, 2011 at 7:45 pm

    #1356845

  • RE: Backup of TX Log: Failed:(-1073548784)

    Warren Peace (7/21/2011)

    GilaMonster (7/21/2011)

    If you want to keep the log managable, back the log up regularly and make sure there are no other problems that cause the log to grow...

    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

    July 21, 2011 at 3:30 pm

    #1356786

  • RE: Backup of TX Log: Failed:(-1073548784)

    Warren Peace (7/21/2011)

    I agree. But when the drives fill up because the TX log files of one (or many) of the DB's TX bloats to 0MB left on the hard...

    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

    July 21, 2011 at 2:57 pm

    #1356764

  • RE: Identifying long running queries SQL server

    Please note: 3 year old thread.

    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

    July 21, 2011 at 2:26 pm

    #1356742

  • RE: Rollback of a Transaction

    chandan_jha18 (7/21/2011)

    Ok. let me more it more interesting. I was logged on to my remote server using citrix or some dial-up connection. now power failure in my city for two...

    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

    July 21, 2011 at 2:23 pm

    #1356738

  • RE: Backup of TX Log: Failed:(-1073548784)

    Warren Peace (7/21/2011)

    Yes, backup log with truncate only is logged. I see it. There's actually a job that does this just prior to the FULL db backup.

    At least the job...

    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

    July 21, 2011 at 2:22 pm

    #1356734

  • RE: Backup of TX Log: Failed:(-1073548784)

    If the log backup is failing with 'no existing database backup' it means that either backup log with truncate only has been run or that the recovery model has been...

    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

    July 21, 2011 at 12:54 pm

    #1356677

  • RE: Rollback of a Transaction

    chandan_jha18 (7/21/2011)

    GilaMonster (7/21/2011)

    If the server crashes, all open transactions are rolled back on restart. It's called crash recovery.

    I meant to say that my workstation or management studio crashed. In that...

    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

    July 21, 2011 at 12:53 pm

    #1356674

  • RE: Database can't be recovered? Any help would be appreciated!!!

    That's just querying sysdatabases, doesn't mean that the DB can be opened (and setting it to emergency mode failed, as did opening it)

    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

    July 21, 2011 at 12:32 pm

    #1356663

  • RE: Database can't be recovered? Any help would be appreciated!!!

    Ignacio A. Salom Rangel (7/21/2011)

    GilaMonster (7/21/2011)

    If CheckDB fails (which is has) there is no point in trying CheckDB with repair, it'll fail too.

    Valid point! I just have a hard...

    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

    July 21, 2011 at 12:15 pm

    #1356653

  • RE: Backup of TX Log: Failed:(-1073548784)

    Something's either running Backup log with truncate_only or switching the DB to simple recovery and back to full. Check jobs, check the error log.

    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

    July 21, 2011 at 12:05 pm

    #1356649

  • RE: Database can't be recovered? Any help would be appreciated!!!

    If CheckDB fails (which is has) there is no point in trying CheckDB with repair, it'll fail too.

    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

    July 21, 2011 at 12:04 pm

    #1356648

  • RE: Profiler Long queries & actual plan & stats

    I'd do this in 2 phases

    1) catch the long running queries. Make note of the names/text of the ones you want to work on

    2) A second profiler trace that grabs...

    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

    July 21, 2011 at 10:59 am

    #1356612

  • RE: Profiler Long queries & actual plan & stats

    There's no extended event for actual execution plans, not even in Denali.

    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

    July 21, 2011 at 10:57 am

    #1356610

  • RE: Database can't be recovered? Any help would be appreciated!!!

    Ignacio A. Salom Rangel (7/21/2011)

    Halifax, You can try to follow the steps in Paul randal's post http://www.sqlskills.com/BLOGS/PAUL/post/CHECKDB-From-Every-Angle-EMERGENCY-mode-repair-the-very-very-last-resort.aspx, instead of using Set Emergency, use the step Gail gave you to change...

    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

    July 21, 2011 at 10:55 am

    #1356608

Viewing 15 posts - 24,751 through 24,765 (of 49,552 total)