Post reply

Any known issues with SP2?

  • July 22, 2008 at 6:39 pm

    #189980

    All,

    I've been asked to come up with a list of know problems with SQL Server after upgrading to Service Pack 2. The only 2 I can directly point to are:

    1) The maint. plan "interval" issues where the plan runs more often than it should.

    2) The intermittant job failures due to a job being owned by a windows group instead of a SQL Login.

    My boss is mainly concerned with SQL Agent & SSIS related issues. But if you know of anything of medium to severe that didn't show up in the SP1 + hotfix version, but started happening after an SP2 upgrade, I'd appreciate the info.

    Thanks,

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • July 22, 2008 at 9:15 pm

    #846780

    I think those were the big things. I've heard that quite a few MVPs feel SP2 + CU6 is very stable.

  • July 23, 2008 at 12:02 am

    #846817

    The first issue is only a problem if you install the first (or is is 2nd?) release of SP2. Rather install SP2 and one of the later CUs. I think 8 is the latest now. I've got servers on CU5 or 6. No problems that I've noticed.

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply