Home Forums SQL Server 2008 SQL Server 2008 Administration Upgrade SQL Server first (05 std to 08 R2 std) or upgrade OS first (in place upgrade)? RE: Upgrade SQL Server first (05 std to 08 R2 std) or upgrade OS first (in place upgrade)?

  • Thanks for all the responses guys. We were actually planning an app upgrade to follow the OS and SQL upgrade but after reviewing the vendor docs it looks like this server's processors are not up to recommended specs. It's several years old and was probably due for a refresh anyway which will hopefully give me an opportunity to build it correctly. Our previous sysadmin had some bad ideas (one tempDB file on the C: drive, simple recovery model, not reserving memory for the OS) and our current sysadmin tried to tell me log shipping causes corruption :laugh:. My role at this company has been strictly focused on the sql server BI stack but it hurts me to see them doing so many things wrong with their mission critical sql server. 🙁