Post reply

Upgrading OS to 2003/Vista - impact on SQL Server

  • May 21, 2008 at 4:18 am

    #121653

    Hi all,

    I need to put together a project proposal for ensuring our database Operations are not unduly affected by upgrades from W2k to XP/Vista.

    We have roughly 100 or so SQL Servers within the estate, mostly SS2K but about 20 instances of 2005, along with a sprinkling of SS7's. We make extensive use of the usual Cross-LAN technologies, ie DTS, Replication etc.

    Currently, some of my concerns involve the obvious connectivity issues, ie ensuring Window's SID's are not broken, XP_CmDshell still works within DTS packages etc etc...

    I'm not sure whether, or more likely how the upgrade will affect Active Directory which in turn will affect database ops.

    My biggest fear is that I might be overlooking something glaringly obvious, so if anyone perhaps has a check list or a Project Plan I could read, and/or suggest any Microsoft/3rd party tools I should run, I'd be very grateful.

    Thanks in advance,

    JB

  • May 21, 2008 at 7:34 am

    #818554

    There's no reason why upgrading your clients would effect the domain controller, so AD will remain in tact.

    I've recently upgraded to vista too, and the only issue I ran across was speed. Everything runs like a dog on it.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • May 21, 2008 at 7:49 am

    #818568

    crever (5/21/2008)

    There's no reason why upgrading your clients would effect the domain controller, so AD will remain in tact.

    I've recently upgraded to vista too, and the only issue I ran across was speed. Everything runs like a dog on it.

    As long as you stick to Vista business or Enterprise of course.... The other versions are all Home/Personal versions, with crippled Windows auth, which can and would cause some issues with staying tied in.

    I've had some luck (notice the word "some") speeding Vista up by turning a lot of the "pretty animation" stuff off, the side bar, killing the transition effects. Amazing how much that stuff takes away.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

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

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