Forum Replies Created

Viewing 15 posts - 1,111 through 1,125 (of 49,552 total)

  • RE: Backup detected log corruption in database

    SQL Galaxy - Tuesday, July 18, 2017 6:03 AM

    Shall I execute “REPAIR_ALLOW_DATA_LOSS†command for resolving this error? It may some data loss 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

    July 18, 2017 at 6:31 am

    #1951368

  • RE: Backup detected log corruption in database

    SQL Galaxy - Tuesday, July 18, 2017 4:41 AM

    3. Start full backup but there is no hope.

    What do you mean?

    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 18, 2017 at 4:51 am

    #1951335

  • RE: Log Shipping-Full backup on primary server

    coolchaitu - Tuesday, July 18, 2017 4:02 AM

    GilaMonster - Tuesday, July 18, 2017 3:16 AM

    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 18, 2017 at 4:20 am

    #1951331

  • RE: Log Shipping-Full backup on primary server

    coolchaitu - Monday, July 17, 2017 10:19 PM

    Why cannot we take regular full backup on primary server in Log Shipping? Does 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 18, 2017 at 3:16 am

    #1951325

  • RE: read after write

    The opposite of the previous definition.

    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 15, 2017 at 1:48 pm

    #1951043

  • RE: Deadlock on TempTable in SP

    jayoub - Friday, July 14, 2017 10:39 AM

    I spoke to the developer and he want to deal with by adding the WITH...

    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 14, 2017 at 3:07 pm

    #1951011

  • RE: why cant we take regular full backup on secondary replica?

    patrickmcginnis59 10839 - Friday, July 14, 2017 8:52 AM

    I'm guessing that the primary difference between a read only replica in an AG...

    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 14, 2017 at 9:49 am

    #1950961

  • RE: Are the posted questions getting worse?

    ThomasRushton - Friday, July 14, 2017 7:19 AM

    $10?  Strewth, I feel ripped off.  I paid about £40 for it back in...

    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 14, 2017 at 7:36 am

    #1950938

  • RE: Are the posted questions getting worse?

    Thom A - Friday, July 14, 2017 1:33 AM

    Chris Harshman - Thursday, July 13, 2017 12:14 PM

    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 14, 2017 at 6:42 am

    #1950916

  • RE: query to track columns which are encrypted via Symmetric Keys

    Sue_H - Friday, July 14, 2017 6:02 AM

    Nice - but unfortunately won't work on SQL 2014. The column encryption views weren'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

    July 14, 2017 at 6:13 am

    #1950911

  • RE: Deadlock on TempTable in SP

    Post the deadlock graph please.

    The deadlock can't be on the temp table (baring a bug in SQL), as those are per-session, each connection has its own copy 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

    July 14, 2017 at 1:44 am

    #1950877

  • RE: Are the posted questions getting worse?

    jasona.work - Thursday, July 13, 2017 2:13 PM

    So reading the posts from Brandie about the job got me thinking (that was 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 13, 2017 at 3:38 pm

    #1950853

  • RE: query to track columns which are encrypted via Symmetric Keys

    SQL-DBA-01 - Thursday, July 13, 2017 1:29 PM

    Is the below query sufficient to find the encrypted columns?


    SELECT stab.name Table_Name, sc.name...

    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 13, 2017 at 3:00 pm

    #1950845

  • RE: Explicit value must be specified for identity column in table 'TABLEA" either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

    Based on the name of that trigger, it may be an update trigger, which won't be affecting this.

    Is there an insert trigger?

    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 13, 2017 at 12:37 pm

    #1950821

  • RE: Explicit value must be specified for identity column in table 'TABLEA" either when IDENTITY_INSERT is set to ON or when a replication user is inserting into a NOT FOR REPLICATION identity column.

    komal145 - Thursday, July 13, 2017 12:19 PM

    I tried disable trigger and insert its not working yet 🙁

    The code you posted...

    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 13, 2017 at 12:22 pm

    #1950817

Viewing 15 posts - 1,111 through 1,125 (of 49,552 total)