Forum Replies Created

Viewing 15 posts - 22,021 through 22,035 (of 49,552 total)

  • RE: suspect database, file backup restore

    No, after they apply the image (which I assume contains the system DBs) then restore master only if necessary.

    As for the suspect DB, depends how badly it's damaged what options...

    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

    November 23, 2011 at 8:53 am

    #1412273

  • RE: transaction log corrupted?

    Rambler (11/23/2011)

    Thanks GilaMonster, I'll try the recovery switch mode once again and see if it comes back again.

    I'll do some additional HW diagnostics if it reveals something.

    If that were my...

    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

    November 23, 2011 at 6:41 am

    #1412136

  • RE: transaction log corrupted?

    CheckDB doesn't check the log, so corruption in the log can still return a clean checkDB.

    About the only way to remove corruption in the log is Paul's solution of switching...

    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

    November 23, 2011 at 5:53 am

    #1412088

  • RE: Partition usage in SQL Server 2008

    The two queries are for two different columns. My guess, the first is filtering on the partitioning column, the second isn't.

    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

    November 23, 2011 at 5:51 am

    #1412086

  • RE: Partition Usage in SQL Server 2008

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1210866-391-1.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

    November 23, 2011 at 5:50 am

    #1412085

  • RE: Checkpoints Clarification

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic1210712-391-1.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

    November 23, 2011 at 1:26 am

    #1411989

  • RE: looking for 70-451 exam

    Passing score is 700, time is around 3 hours, scoring system is secret.

    What do you mean by "I want to know the exam real questions"?

    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

    November 23, 2011 at 1:25 am

    #1411988

  • RE: suspect database, file backup restore

    No backup of master?

    There's a procedure for rebuilding master in Books Online. I suggest you find and follow 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

    November 23, 2011 at 1:24 am

    #1411986

  • RE: rebuild index

    Let me guess, tiny table, index about 5 pages in size?

    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

    November 23, 2011 at 1:23 am

    #1411985

  • RE: rebuild index

    Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic1210728-146-1.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

    November 23, 2011 at 1:22 am

    #1411984

  • RE: Shrink and backup

    Chris Metzger (11/22/2011)

    Am I just being blase about it or are some ppl just overly paranoid?

    Both.

    Am I correct in saying you've never dealt with a disaster scenario?

    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

    November 22, 2011 at 4:26 pm

    #1411905

  • RE: Shrink and backup

    Chris Metzger (11/22/2011)

    Jim (and anyone else): there will NEVER be a controller failure.

    I'd be very hesitant to say 'never'. Very, very unlikely, sure, but I've seen a controller...

    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

    November 22, 2011 at 2:58 pm

    #1411866

  • RE: Processor license of SQL server

    Evil Kraig F (11/22/2011)

    I have a feeling as a consultant I need to get VERY comfortable with SQL2k8R2 since that's going to be around for a looong time. Of...

    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

    November 22, 2011 at 2:51 pm

    #1411856

  • RE: number of executions don't match number of rows -- Nested Loops

    DenisT (11/22/2011)

    For example, Node ID 19 returns 721 rows but Node ID 21 is executed only 669 times -- according to the Nested Loops join definition, should've been executed 721...

    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

    November 22, 2011 at 2:42 pm

    #1411850

  • RE: Processor license of SQL server

    okbangas (11/22/2011)

    Ninja's_RGR'us (11/22/2011)

    Sql 2012 will charge by cores.

    With a minimum of 4 cores per processor. So, if you have a dualcore CPU, you'll still pay for a quad core.

    That said,...

    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

    November 22, 2011 at 2:16 pm

    #1411821

Viewing 15 posts - 22,021 through 22,035 (of 49,552 total)