Forum Replies Created

Viewing 15 posts - 1,336 through 1,350 (of 9,707 total)

  • RE: sql backup

    Jeff Moden (10/19/2016)


    Steve Jones - SSC Editor (10/19/2016)


    Jeff Moden (10/18/2016)


    Using compress backups and having a really good team that put together some remarkable hardware, I'm backing up 2.3 TeraBytes to...

  • RE: Parameter on Powershell Script

    Luis Cazares (10/19/2016)


    Brandie Tarvin (10/19/2016)


    Have you tried renaming the folders to use underlines instead of hyphens?

    I think the hyphens are the problem. That powershell might see them literally as a...

  • RE: Are the posted questions getting worse?

    On a fun note, my past 24 hours has been taken up by an AG issue which has caused one secondary replica not to synchronize, which caused the log files...

  • RE: Are the posted questions getting worse?

    Gazareth (10/19/2016)


    Gazareth (10/19/2016)


    Eirikur Eiriksson (10/18/2016)


    Just had a Blast from the past

    😎

    First line: "Version 4.2 also lets you nest triggers"

    I didn't get any further due to blacking out; came to 10...

  • RE: With recompile in the master stored proc

    river1 (10/18/2016)


    Separated sql tasks means that each species is executed inside is sql tasks. Task are connect through success arrows ( green arrows). So, exactly as the sp I...

  • RE: log is full due to Availability Replica

    Perry Whittle (10/19/2016)


    Brandie Tarvin (10/19/2016)


    Are you taking log backups of your primary AG database? If not, then expect it to fill up and not clear.

    you can offload log backups to...

  • RE: log is full due to Availability Replica

    patrickmcginnis59 10839 (10/19/2016)


    Brandie Tarvin (10/19/2016)


    patrickmcginnis59 10839 (10/19/2016)


    Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of...

  • RE: Parameter on Powershell Script

    Have you tried renaming the folders to use underlines instead of hyphens?

    I think the hyphens are the problem. That powershell might see them literally as a switch "notifier" kind of...

  • RE: log is full due to Availability Replica

    patrickmcginnis59 10839 (10/19/2016)


    Anything could cause the secondary to not be synchronized. Things like taking differential database backups of the primary, which will disrupt the flow of data from primary to...

  • RE: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the...

  • RE: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the plot.

    are you sure...

  • RE: Are the posted questions getting worse?

    BLOB_EATER (10/19/2016)


    rodjkidd (10/19/2016)


    ChrisM@Work (10/19/2016)


    BLOB_EATER (10/19/2016)


    Brandie Tarvin (10/19/2016)


    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the...

  • RE: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    rodjkidd (10/19/2016)


    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the plot.

    are you sure it wasn't ......

  • RE: Are the posted questions getting worse?

    ThomasRushton (10/19/2016)


    In other news, today I overheard m'colleague saying "maybe the DBA team would be a beacon..."

    at which point I lost the plot.

    Oh, oh, oh.

    May I steal this for a...

  • RE: sql backup

    It also depends on if you're doing a FULL, DIFFERENTIAL, or TRANSACTION LOG backup. Diffs will always be faster than FULLs unless things change really fast and really often, which...

Viewing 15 posts - 1,336 through 1,350 (of 9,707 total)