With MSSQL8 being upgraded to SQL2008, I was wondering if there is a comprehensive list of what SQL Versions are on what server?
Sorry if I missed a list elesewhere.
Not yet a list, but right now it is:
MSSQL1-7 SQL 2000
MSSQL8 SQL 2008 R2
MSSQL9 SQL 2000
MSSQL10-12 2005
MSSQL13 SQL 2008 R2
CL1-MSSQL4 this morning I was tempted to shoot for 2008 upgrade now that I know the query governor bug, but frankly I had 3 hours total sleep in the prior 60 hours and was in no place mentally to do it, and it was getting into daytime already. I will probably plan it over a weekend at some point, we need to get the upgrade done and legacy gone away.
I plan to upgrade MSSQL1/2/3/5/6/7 in migration and MSSQL9 as well. I skipped over MSSQL9 for a few reasons but mostly because it is a very busy server that was in place at a time of big growth, and I didn’t want to overload a node with it, it will be either on a standalone node or a node specially built to handle the high IO needs.
on CL2:
MSSQL1-3 SQL 2005
MSSQL4 SQL 2008 R2
Great, thanks for the reference.
oh, and get some sleep!
Ok, what’s the update on MS SQL Versions? On mssql9 it’s still 2000. Will this server ever be upgraded?
Yes we will, we updated mssql8, and had a few issues, some immediate wanted to blame upgrade etc
It also took about 2 hours longer than expected, so we decided on future migrations we will stay same version.
This has done well, the servers have performed well, if not far better than prior even.
we will announce a week prior to upgrades when we do them, and likely start with mssql9 when we proceed. It will be to sql 2008, not 2005. (Mssql8 was also 2008 and working well)
We have learned through it some of the large db we will need to do a fulll text index rebuild, rebuild all indexes, update stats and shrink, otherwise performace is not to 2008 standard level.
Also, we wont do them all one weekend, but spread over some saturday early mornings for 3 weekends or so.
Any news on MSSQL DB versions? Is the above list still correct?
Also not all DB servers have a backup/restore WEB-UI, during migrations to WACO this was promised… Any news on this? I would be happy to have one on CL1-mssql3.
The backup/restore app is not working well and not been updated by developer. It was with a .net update that it broke. The developer is a friend I will see if he can update it or not.
Versions correct yes.
Hi Stephen, Thanks for your reply. Would be great if backup/restore can be a reliable feature.