October 21, 2011 at 3:25 am
I still have a fair number of SQL2000 installs out there. I am trying to upgrade or retire all of them but it is difficult as the application support people have no incentive to upgrade these older but stable and reliable systems. Especially as application support is outsourced and they have no financial incentive to do upgrade work and would rather work on new projects (for which they get extra money).
A lot of the database upgrades wouldn't get done except application upgrades come along which require later versions of SQL than 2000.
I find the DTS issue is a limiting factor at first but when they realise what SSIS skills mean for their CVs they are keener!
---------------------------------------------------------------------
October 21, 2011 at 3:43 am
+1 for DTS on migration, that's why I still have 2000,2005,2008 running for different projects
October 21, 2011 at 5:24 am
2005 & 2008r2. Mostly 2005 with new projects going on 2008r2.
October 21, 2011 at 5:48 am
We have upgraded all of our systems to 2008 R2. Whenever a new release comes out, we are all over it, upgrading our SQL Server systems at the first opportunity as soon as we have developed at least one version of our company software using the release. We absolutely HATE being on old releases of software, and it's worked out well for us being able to take advantage of the latest functionality in each area.
October 21, 2011 at 5:51 am
SQL2000 SP4 (till the hardware breaks, no DTS), SQL2005 & SQL2008 (not yet R2). All standard or express editions. Next to Oracle 9 and 10.
October 21, 2011 at 6:08 am
I work as the only DBA for a large healthcare organization in my area. I got hired 6 months ago to fill in this position as it did not exist before. I can't say I am a savy DBA as my previous IT experiences did not relate to that. I can say I kind of got hired right out of school after my second degree in Database Administration. Even with only academic experience, I see new things everyday that amazes me. Currently I support around 80 servers with about 500 Databases. With no one before taking care of that many systems, there is a lot of work to be done. We still have about 12 to 14 SQL 2000. I recently have just started implementing R2's. It is very challenging to upgrade when most of our vendors do no support highers versions. In January, I am hoping I will have my SQL Cluster project approved. If it is, I will be replacing 7 physical servers that are holding SQL 2000. The proposed replacement is 3 mighty Cisco UCS blades that will act as an active/active cluster rather than independent instances. This should provide sufficient resources and opens the door for expandability.
October 21, 2011 at 6:09 am
2 - SQL 2000 hosting production databases (due to my company not wanting to upgrade to the latest versions of the applications)
10 - SQL 2005
2 - SQL 2008
4 - SQL 2008 Express
4 - SQL 2008 R2
1 - SQL "Denali" CTP 3 (already developing tabular data models and using "Crescent")
October 21, 2011 at 6:18 am
4 x 2000 (archived data)
10 x 2008 R2
October 21, 2011 at 6:22 am
We have one v7, two with SQL 2000, two with SQL 2005 and one SQL 2008 R2 (not in production yet). The older ones are running with some old legacy systems and are realy not used very heavily and just keep plugging along.
Donald Mayer
Oswego Health
October 21, 2011 at 6:26 am
We have about 40 SS 2000, about 50 SS 2005, a couple SS 2008 and maybe 5 SS 2008 R2. We are still running DTS packages under SS2005 and I was recently asked, "How do we run DTS under SS 2008?". I told them not to do it. 🙂
October 21, 2011 at 6:34 am
Only 1 SQL2000 server left
2000 = 1
2005 = 5
2008 = 7
2008R2 = 4500
October 21, 2011 at 6:43 am
For us, the versions supported are dictated by vendors. We are a mixed bag of 2000, 2005, 2008R2 with one 6.5 thrown in for good (bad?) measure. The 6.5 db is for a card system that captures time in/out punches and forwards them to our IBM i for time and attendance and payroll. That system will be gone by the end of the year.
October 21, 2011 at 6:48 am
We have only 2005 and 2008 R2 boxes as we forced users along to newer versions. I have worked for companies in the past that keep really old versions because the vendor went out of business and they were afraid to move the databases...LOL
Ed Watson aka SQLGator
Microsoft SQL Server MVP
Follow me on Twitter!
Go Gators!
October 21, 2011 at 6:49 am
EricEyster (10/21/2011)
Only 1 SQL2000 server left2000 = 1
2005 = 5
2008 = 7
2008R2 = 4500
4500????????????????????????????????????????????????????????
October 21, 2011 at 6:49 am
I support SQL 2000 Standard, 2005 Standard and Enterprise, 2008 Standard and Enterprise and 2008R2 Standard.
Viewing 15 posts - 16 through 30 (of 78 total)
You must be logged in to reply to this topic. Login to reply