SQL 7.0 server failure

Today was not a good day, but it wasn’t a bad day either.
We’ve got a couple legacy vendor apps that still have to run on MS SQL 7, one of which “brands” the server on install. So, we’ve been hesitant to move it off the 4+ year old NT4 server that it was originally installed on. That got hurried along today, as the RAID1 logical drive the OS was installed on suffered a simulataneous failure of both drives.
Luckily, the OS was still functional enough to:

  1. Stop the SQL server service
  2. Copy off the SQL data files

After grabbing those, we proceded to install a new server (glad we had some spare new hardware laying around) with Windows 2000 and SQL 7. Because we kept the drive layout identical to the failed server, we could change the raw database files “under the hood” and it would still work (cross your fingers). After patching it up to the same level as the failed server, stop the SQL service, move the existing Data, Logs and Backups folder out of the MSSQL7 folder and move the copies off the failed server in, start the service….Bingo, users, data, sps, maintanence plans, the whole shebang came along just fine….

Yay for applications that don’t use the registry to store all their configuration data. I’ve got to give some of the credit for this to Marty, he first tried this when migrating another one of our database servers from Windows 2000 to Windows Server 2003. It worked flawlessly on SQL 2000, I figured it was worth a try on SQL 7 also.

Then this afternoon I got to shift gears completely and work on proxyarp on a LEAF router I installed as a consulting job. Now I just hope the ISP can make their registration system work with our kludge.

URHNet Day 6

We’re pretty much up to full capacity. I’m not sure of the final number, but the URHnet management system says just under 9800 residents. On the network side, we’ve got 5579 jacks, with 4885 active as of tonight.
So far there haven’t been any major issues (I’ll go knock on wood now), a couple “micro-outbreaks” of some newer Rbot variants, but nothing like 2 years ago. With all the extra we’ve put into service, we’ve found some wiring issues and had a few rooms we couldn’t easily manage. Just over 100 tickets open right now, and the nettechs have been staying on top of them pretty well.

In all, this has been a fairly smooth opening.

URHNet Day 3

Day 2 wasn’t very eventful, no one was scheduled to move in on Friday.
Today has been a big day. The Information Office people told me that 75% of our residents are moved in now, which is hard to believe. According to the boss, as of 5:30 pm today: 600 new IPs given out today and we’ve loaned out 2500 hubs this week. Less than 75 open tickets right now, but I expect more later tonight and tomorrow.

We’ve got a ways to go to get up to full, but we’re getting there.