Forum Replies Created

Viewing 15 posts - 23,551 through 23,565 (of 49,552 total)

  • RE: question about DR (recovering a sql server)

    I'm guessing that for some strange reason the server guys are re-imaging the DR server from tape. That's an exceedingly odd approach....

    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 9:02 am

    #1380731

  • RE: What do you do when it's slow?

    Fire up an MCM training video.

    Edit: that's a hypothetical answer, I haven't been in a situation with nothing to do for months.

    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:51 am

    #1380722

  • RE: Automatically take a Transaction log backup in SQL SERVER.

    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...

    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:49 am

    #1380721

  • RE: Automatically take a Transaction log backup in SQL SERVER.

    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:38 am

    #1380711

  • RE: truncate first or drop index firast, which is faster?

    THE-FHA (9/13/2011)

    Truncate is not logged so i would assume it being faster!

    Myth!

    http://sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281930%29-TRUNCATE-TABLE-is-non-logged.aspx

    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:35 am

    #1380703

  • RE: Automatically take a Transaction log backup in SQL SERVER.

    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...

    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:32 am

    #1380699

  • RE: Automatically take a Transaction log backup in SQL SERVER.

    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:26 am

    #1380691

  • RE: Seek with non-clustered index

    Not sure what you're looking for, but an index seek on a nonclustered index is just called an index seek (as opposed to a clustered index seek) and is the...

    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:22 am

    #1380686

  • RE: DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2

    halifaxdal (9/13/2011)

    A backup room is being seeked and hopefully we find it so we don't have to do the fix on the real prod server

    If you don't have another server,...

    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:19 am

    #1380682

  • RE: DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2

    halifaxdal (9/13/2011)

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

    Get Gail in for a consult. Can't be done over forums.

    I would love to, but if that costs any expense, then I personally can't make it.;-)

    Absolutely, I'd...

    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:17 am

    #1380678

  • RE: DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2

    halifaxdal (9/13/2011)

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

    halifaxdal (9/13/2011)

    GilaMonster (9/13/2011)

    Run SP_configure and set allow updates to 1. Update sysdatabases for that database and set the status to 32767.

    Then see if you can access the DB...

    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:16 am

    #1380677

  • RE: Runaway transaction log... No open transactions, no long running transactions????

    Please post new questions in a new thread. Thank you.

    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 5:46 am

    #1380530

  • RE: Mirroring and Back-up strategy

    kapfundestanley (9/13/2011)

    So you mean on top of the daily back-ups i am taking, i need to take Daily transaction logs as well?

    Daily, no. Hourly more like it. Every 15 min...

    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 5:45 am

    #1380527

  • RE: DB corrupted with event 17052 and Error: 823, Severity: 24, State: 2

    halifaxdal (9/13/2011)

    GilaMonster (9/13/2011)

    Run SP_configure and set allow updates to 1. Update sysdatabases for that database and set the status to 32767.

    Then see if you can access the DB and run...

    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 5:42 am

    #1380525

  • RE: dbcc to recover corrupt pages

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

    Any way to do a page restore from and older backup + all log backups?

    Yes.

    http://msdn.microsoft.com/en-us/library/ms175168.aspx

    Google down in your neck of the woods?

    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 5:39 am

    #1380523

Viewing 15 posts - 23,551 through 23,565 (of 49,552 total)