Forum Replies Created

Viewing 15 posts - 21,931 through 21,945 (of 49,552 total)

  • RE: SQL 2008 Logshipping, secondary database issue

    Ok, that pretty much eliminates the 'copy to external harddrive and drive the backup over' that I was going to suggest.

    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

    December 2, 2011 at 2:56 pm

    #1416196

  • RE: SQL 2008 Logshipping, secondary database issue

    MyDoggieJessie (12/2/2011)

    Again, it will take 18 hours to copy a full backup up to the our DR location (due to it's size - 88GB compressed via Hyperbac)

    What's the distance between...

    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

    December 2, 2011 at 2:39 pm

    #1416187

  • RE: Indexing queries

    It's also great when people here post unreadable piles of garbage and expect the person helping them to figure it out.

    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

    December 2, 2011 at 12:25 pm

    #1416159

  • RE: SQL 2008 Logshipping, secondary database issue

    MyDoggieJessie (12/2/2011)

    If I restore the full backup, then apply the last differentials to the secondary server AND a new full backup occurs on the primary server during that time, won'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

    December 2, 2011 at 12:24 pm

    #1416158

  • RE: SQL 2008 Logshipping, secondary database issue

    Err, no...

    I mean there's no point in restoring the last successful log backup WITH RECOVERY, then shrinking the log, then restoring the full backup over that, followed by the last...

    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

    December 2, 2011 at 11:40 am

    #1416128

  • RE: SQL 2008 Logshipping, secondary database issue

    p.s. there's no point in recovering the database, shrinking the log and then restoring a full backup over it. The restore will wipe out the existing DB and replace 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

    December 2, 2011 at 11:31 am

    #1416123

  • RE: SQL 2008 Logshipping, secondary database issue

    MyDoggieJessie (12/2/2011)

    What I mean is if I'm going to restore this current full backup, then restore the sequential differential backups, if that time overlaps with the next full backup 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

    December 2, 2011 at 10:43 am

    #1416086

  • RE: SQL 2008 Logshipping, secondary database issue

    Dev (12/2/2011)

    GilaMonster (12/2/2011)

    MyDoggieJessie (12/2/2011)

    ...can I restore just the last differntial back, then restore the TRN files since that backup?

    No, once you recover the database no more backups (differential...

    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

    December 2, 2011 at 10:32 am

    #1416076

  • RE: SQL 2008 Logshipping, secondary database issue

    MyDoggieJessie (12/2/2011)

    ...can I restore just the last differntial back, then restore the TRN files since that backup?

    No, once you recover the database no more backups (differential or log) can be...

    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

    December 2, 2011 at 10:18 am

    #1416059

  • RE: Are the posted questions getting worse?

    Stefan Krzywicki (12/2/2011)

    That said, I love the video of the cat opening the fridge and am very thankful mine never learned that trick.

    Likewise. One of mine has made several attempts...

    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

    December 2, 2011 at 8:38 am

    #1415947

  • RE: Does rebuilding a clustered index effect non clustered index.

    george sibbald (12/2/2011)

    oh yes.... a point to me I do believe 😉

    1/4 of a point, since your post is 1/4 of mine. 😉

    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

    December 2, 2011 at 8:21 am

    #1415923

  • RE: I need a deadlock in SQL Server 2008R2, Win 7 64-bit

    My favourite way to generate a deadlock is like this:

    Window 1

    BEGIN TRANSACTION

    UPDATE <someTable> SET <whatever> WHERE <pk column> = @value1

    WAITFOR DELAY '00:00:05'

    SELECT * FROM <SomeTable> WHERE <pk column> ...

    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

    December 2, 2011 at 8:19 am

    #1415921

  • RE: Are the posted questions getting worse?

    Stevie gonna lovez uz.

    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

    December 2, 2011 at 8:17 am

    #1415917

  • RE: Does rebuilding a clustered index effect non clustered index.

    Elliott Whitlow (12/2/2011)

    I think we are going to have to agree to disagree as far as SQL 2000 is concerned, I am 99.999% sure I can show that it does...

    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

    December 2, 2011 at 8:14 am

    #1415916

  • RE: Are the posted questions getting worse?

    Iz a headache. Andz nos just from z codes Iz working with. (But goggie writz better codes than thiz)

    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

    December 2, 2011 at 7:59 am

    #1415909

Viewing 15 posts - 21,931 through 21,945 (of 49,552 total)