Forum Replies Created

Viewing 15 posts - 27,316 through 27,330 (of 49,552 total)

  • RE: Mirroring

    Then you have auto failover. If the principal fails, the mirror will come online automatically. If client apps are using SNAC, they will redirect automatically as well

    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

    March 17, 2011 at 6:00 am

    #1299882

  • RE: Restore db from ..

    Was there no other full backup of the test server? If not, that may actually work, the diff would not have succeeded if there wasn't a full backup around. Try...

    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

    March 17, 2011 at 1:56 am

    #1299820

  • RE: transaction log back up failed

    annasql (3/16/2011)

    Does that mean every time if there is some options changed we need to do a full backup, or can I do a diffrential back up, so that 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

    March 17, 2011 at 1:54 am

    #1299817

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/16/2011)

    GilaMonster (3/15/2011)

    WayneS (3/15/2011)

    Now I really want to see it! Good job on insulting any and all... sounds like Jeff and his pork chop launcher might be rubbing off on...

    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

    March 16, 2011 at 2:16 pm

    #1299639

  • RE: Are the posted questions getting worse?

    CirquedeSQLeil (3/16/2011)

    just follow those particular individuals

    Buck Woody

    Paul Randal

    Robert Davis

    michelle Ufford

    Gail Shaw

    Paul White

    Jonathan Kehayias (sp)

    Brent Ozar

    Jeremiah Peschka

    Kendra Little

    Karen Lopez

    Steve Jones

    Jorge Segarra

    To name a few - they all provide quite interesting conversation...

    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

    March 16, 2011 at 2:04 pm

    #1299636

  • RE: Property Owner is not available for Database - root cause?

    dbo stands for database owner. It's the user that all sysadmin logins map to. (and whatever login is set as the database owner)

    Recommendation for database ownership - sa. It'll always...

    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

    March 16, 2011 at 1:57 pm

    #1299632

  • RE: Restore db from ..

    annasql (3/16/2011)

    My question is when a full backup succeeded, but a diffrential back up failed, 3 transactions are OK. can I restore the database, by just using full backup, and...

    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

    March 16, 2011 at 1:31 pm

    #1299624

  • RE: transaction log back up failed

    There's been either an explicit log truncation or a switch to simple recovery (and back to full) since the last full/diff backup

    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

    March 16, 2011 at 1:30 pm

    #1299623

  • RE: SQL Server is down

    SQL error log, windows event logs

    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

    March 16, 2011 at 11:02 am

    #1299506

  • RE: Transaction log usage

    Steve Jones - SSC Editor (3/16/2011)

    Also keep this in mind. If you do a large transaction, maybe a large update. You need log space for the update PLUS log space...

    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

    March 16, 2011 at 11:01 am

    #1299503

  • RE: error 823

    Another Diskeeper-related corruption problem... http://sqlskills.com/BLOGS/PAUL/post/Diskeeper-10-Intelliwrite-corruption-bug.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

    March 16, 2011 at 10:48 am

    #1299496

  • RE: Msg 207 in CASE when select statement working

    mgodfrey 54349 (3/16/2011)

    Worked. Don't understand why it can't see the field names from the first select but in any case your suggestion worked.

    Because each select is independent. 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

    March 16, 2011 at 10:47 am

    #1299495

  • RE: Mirroring

    Huh?

    Synchronous or asynchronous? Do you have a witness 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

    March 16, 2011 at 10:39 am

    #1299491

  • RE: Mirroring

    That depends what mode your mirroring is running in and whether or not you have a witness 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

    March 16, 2011 at 7:35 am

    #1299356

  • RE: Msg 207 in CASE when select statement working

    select @DayGood =

    CASE

    WHEN @Dayin = 1 and RMS_Sunday = 1 THEN 'N'

    WHEN @Dayin = 2 and RMS_Monday = 1 THEN 'N'

    WHEN @Dayin = 3 and RMS_Tuesday = 1 THEN 'N'

    WHEN...

    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

    March 16, 2011 at 7:24 am

    #1299349

Viewing 15 posts - 27,316 through 27,330 (of 49,552 total)