Migrating SQL Server 2000 to a new machine

I’ve recently had the dubious pleasure of migrating a SQL Server instance from one machine to another, not a simple task in  complex setup. Here are some notes that might be of use to other people who need to do this.

Say we have a database server called DBSERVER and we want to upgrade to new hardware without messy stuff like moving drives around. First we install the operating system on the new machine and call it NEWSERVER, simple enough so far. Next we install SQL Server 2000 on NEWSERVER, here it’s important to make sure you use the same collation setting as the old server while installing SQL Server or you are going to end up doing it all over again.

NEWSERVER now has a completely blank SQL Server instance on it, so we can start copying stuff around. The basic procedure goes as follows:

  1. Copy logins
  2. Copy DTS packages
  3. Disable SQL Agent jobs on DBSERVER
  4. Detach the databases on DBSERVER
  5. Copy the database files over to NEWSERVER
  6. Rename DBSERVER to something else (say OLDSERVER)
  7. Rename NEWSERVER to DBSERVER
  8. Update some SQL Server internals in DBSERVER (the new one) to make sure it has the right internal name
  9. Attach the databases on NEWSERVER
  10. Recreate SQL Agent jobs on DBSERVER

Copy logins

I found a useful page here on Microsoft‘s web site that makes migrating logins relatively simple and quick, I went for Method 1 under “A complete resolution to transfer logins and passwords between different version of SQL Server”.

Copy DTS packages

Note that this only works with Local Packages. I found a page here that gives some methods of copying DTS packages between SQL Server instances, the method I went for is the one describing how to use a DTS to transfer them.

Disable SQL Agent jobs on DBSERVER

This step is done now to prevent automated jobs from trying to access offline databases. Just select each job, right-click and click “Disable job”. If “Disable job” is unavailable for any jobs, see this page for help.

Detach databases

Note that your databases will be unavailable from this point on until they are attached again on the new server. This is just a matter of right-clicking on each of your databases (not the system databases master, model, msdb and tempdb) in Enterprise Manager and selecting “Detach database” in the “All tasks” menu.

Copy databases

Now you need to copy the .MDF and .LDF files from the SQL Server Data folder on DBSERVER to the corresponding folder on NEWSERVER, again making sure not to copy system databases. This step can take some time, so grab a cup of coffee.

Rename the servers

This is an operating system task, I’ll leave it up to the gentle reader to work out. It may be a good idea to actually move IP addresses around a bit too (so give OLDSERVER some new IP address and move the IP that was on DBSERVER along with the name).

Update SQL Server internals to the new names

Again I refer you to this page on how to do this, as a minimum I suggest:

On OLDSERVER do:

sp_dropserver 'DBSERVER'
sp_addserver 'OLDSERVER'

On NEWSERVER do:

sp_dropserver 'NEWSERVER'
sp_addserver 'DBSERVER'

Attach databases

This is again done in Enterprise Manager, you want to attach all the databases you have copied over and do some checks to make sure they are OK (check that the logins are OK at least).

Recreate SQL Agent jobs

How this is done depends on your setup. Basically you will need to recreate all the needed SQL Agent scheduled jobs on the new server.

Posted in Systems admin | 1 Comment

Ongoing phishing attack against ABSA Bank

As network manager at my work, I get to see a lot of spam and it’s my job to update the anti-spam systems to combat this junk. Something that I see a lot of, and that my users are reporting a lot of to me as well, is phishing emails claiming to be from ABSA online banking.

What seems to be happening is that there is someone (probably a group of people) hacking web servers at a tremendous rate and using those hacked servers to host pages that look like the ABSA online banking login page. Then they send out spam to huge numbers of people that look like messages from ABSA, prompting the recipient to click on a link to “confirm their login details” or “read important information”, the link in the email then goes to the hacked website. If someone does enter their online banking details, the hackers have those details and all kinds of nasty things can be done.

ABSA have, for a long time, had a number of security measures in place to combat this kind of thing, including their RVN (Random Verification Number) SMS system that sends an SMS with a code to your cell phone that you must then enter on the site to perform certain actions. ABSA have also made it abundantly clear many times that they will never send email to customers prompting them to click on a link and enter their details.

Some generic advice from me:

  • Do not click on links in email that claims to be from your bank
  • If you are a customer of ABSA, always make very sure the address of the site you are on (in the browser address bar) starts with https://ib.absa.co.za/ before entering any detals
  • Make sure you have the maximum number of security measures in place with your bank, including SMS notification and RVN
  • Make sure your bank has the correct cell phone number for you
  • Err on the side of caution, or as I sometimes put it, be paranoid because just because you’re paranoid doesn’t mean they are NOT out to get you
  • If possible, report phising emails to someone who can put technical measures in place to filter further ones

On the last point, my filter procedure not only blocks further emails mentioning the hacked site, they also block that site on the corporate web proxy servers so that browsers on the corporate network can’t access them at all.

It’s worth noting that, even though ABSA seems to be the most common target in South Africa at the moment, they are by no means the only. I have even recently seen a couple of phising emails that claimed to be from the South African Revenue Service, now there is a scary thought.

Update 2010-03-08: I’ve been having a peek through my blog logs and I notice this post is getting a couple of hits from Google search results about ABSA phishing and hacks, including some about reporting it to ABSA. Naturally, people are free to report every phishing mail to ABSA, but don’t expect that to fix the problem because this is a pretty big problem that is not going to go away easily. I am not aware of any law enforcement investigations into this issue, but then I’m just a concerned individual and customer so I wouldn’t know. Having said that, I feel it would be very important to contact your bank (be it ABSA or any other bank) if you had actually entered data on one of these phishing sites, as some action will be needed to limit the damage it may cause to you.

Posted in Internet Security, Web stuff | 2 Comments

The buzz about Buzz

So yesterday Google announced Buzz, their new social-stream-twitter-facebook-friendfeed-kinda-thing product. I’ve been waiting for Buzz to appear in my Gmail account, but so far nothing yet (hey Google? I’ve been a Gmail user since the days you had to get invited to be one, think I might get Buzz some time soon?). What I wanted to comment on are some of the reactions to Buzz.

Both Microsoft and Yahoo! PR people have weighed in by saying that they have had similar products for some time, neither of which I ever heard of. Frankly I (and I think very many other people) don’t use Hotmail or Yahoo! Mail, because Gmail does web mail right, so why would we be interested in stuff in Hotmail and Yahoo! Mail that didn’t even get any attention when they launched?

I think this comment on a TechCrunch post about Paul Buchheit’s initial reactions to Buzz kind of summarizes what I want to say on this matter right now:

Google didn’t invent web mail either. OHNOEZ.

They just made it *great.*

All of the look-at-me-too crowd crying about Buzz are making themselves look extremely foolish. Aggregation of social content is about as obvious a feature as it gets for a company like Google to offer. It’s not some new idea created by the likes of Yahoo, MS, or FriendFeed, or Facebook.

Google Buzz looks like it’ll be a *great* as well.

Posted in Uncategorized | Comments Off

Last “personal stuff” blog post

Some people who know me and notice things on my blog might notice that some posts have been removed. It seems some things I’ve done and said online in the past have contributed to recent events in my life in a negative way, whether through misinterpretation of what was said months ago or not seeing the full context I don’t really know and by this stage don’t really care either, I just know I wasn’t ever asked about the context in which things were posted.

So anyway, I’ve deleted my FriendFeed account and protected my Twitter feed from public view. In addition I’ve deleted a number of news feed items on Facebook and also removed a bunch of blog posts.

Posted in Diary | Comments Off

Video tutorials and accents

Recently I’ve been browsing YouTube, just randomly stumbling around out of boredom. A couple of videos I’ve watched in the last couple of days have been about the South African accent and how people sometimes struggle to understand what we are saying. Now I have to admit I struggle to understand what some people in my own country, even in my own city, are saying sometimes. But that aside, this got me thinking about some technical video tutorials I’ve watched over the years.

From time to time I’ll come accross a situation where the only way to find out how to do something in a piece of software without sitting through hours of trial and error is to watch someone’s video tutorial about how to do it. People seem to think it would be easier to understand things if you watch a video about it, which is only true if the person watching the video happens to have grown up with the same accent as the person speaking in the video. I’ve watched some videos on Photoshop where the person presenting the information speaks so fast in some American accent that I give up trying to understand after a couple of minutes and just go for the trial and error method instead.

So here’s my advice to makers of video tutorials. Remember that the vast majority of people watching your video are likely to be outside your region, and many will be outside your country. English is a very widely spoken language, and it is spoken in a huge array of regional and national accents. So slow it down a little and try to make it clearer for someone like me to understand what you are trying to say, we want to learn about the subject of your video and don’t still want to learn how to undertand your regional accent first.

Posted in Random thoughts | Comments Off

The mean streets of Summerstrand

Summerstrand in Port Elizabeth has always been perceived as a bit of an upmarket suburb. This image is being spoiled a little by the increasing number of beggars and drunks who seem to be making the streets around Summerstrand Village shopping center their stomping grounds. I live within an easy 2 minutes walk of Summerstrand Village and this trend concerns me.

As an example, allow me to describe the experience of my stroll to Pick n Pay at Summerstrand Village at about 5:30 this afternoon. Walking there, I noticed a couple of scruffy looking people on the shopping center side of the street, so I stuck to the far side of the street as far as possible, one of the scruffy looking men walked to the corner to harass me for money. In the center itself there was a beggar sitting on a bench, when I walked past him without so much as looking at him he started shouting something about being a racist after me. On the way home I again crossed the street as soon as possible to walk home on the side of the street away from the center. Right outside my driveway gate a beggar came running across the street to harass me for money. This one actually looked like he wanted to attack me when I told him I had nothing for him, so I ducked in the gate and closed it in a hurry.

I have in the past, often on weekends, seen drunks fighting and screaming in the streets around the shopping center. Once I nearly had to call the police because it looked like a drunk man was about to stab a drunk woman with a broken bottle.

It’s gotten to the point where I, a 6 foot 2 man, am nervous when I walk to the shopping center on my own. I will most certainly not walk there if my girlfriend is with me. After today’s little trip of “joy” I find myself wondering if I even want to walk there at all, perhaps it would be easier and much safer to get in my car and drive somewhere else when I need to go to a shop rather than running the gauntlet of beggars and drunks in the mean streets of Summerstrand.

Posted in Random thoughts | 2 Comments

Unseen Academicals

Unseen

I’ve just finished reading Terry Pratchett’s delightful Unseen Academicals over the span of two days.

As with most of Pratchett’s work, this novel takes aspects of our normal day to day existence and gives them new meaning. The core plot thread in this novel is around the game of football (or soccer, if you use the name football for a game involving an oval ball) and the sometimes very scary fanaticism that revolves around it. He describes the good of being part of the crowd, but he also shows the dark underside of the football fan in the form of violent hooligans. In fact the efforts of the Patrician, with the help of Unseen University, to make football a more civilized and safe game are almost undermined by the fact that the hooligan element in the crowd had over time gained more control over the game than the actual football clubs had.

In terms of cast, this is definitely an Unseen University book. We see some interesting changes in the staff of Unseen University, with the Dean having departed for greener pastures in Pseudopolis and so many jobs delegated to poor Ponder Stibbons that he in fact now holds a controlling vote at the university council because of the number of posts he holds. So despite Archchancellor Ridcully obviously being the head of the university and wizards (“first among equals”), Stibbons is in fact the person in charge. Rincewind is in this book, but essentially just as a background supporting character, there is one little passage that illustrates why Ridcully keeps his Professor of Cruel and Unusual Geology around, I won’t quote now but it boils down to Rincewind being lightning rod for trouble and drawing it away from the other wizards.

We see a lot more of the “below stairs” UU staff, in fact they are the main characters in the book. There is Glenda who runs the Night Kitchen, her friend and assistant Juliet who is destined to be the greatest fashion model ever, Trev who runs the candle maker vats and a candle dribbler called Nutt with some huge and important surprises up his sleeves. This book is in fact also the story of Mister Nutt, who has had a more difficult childhood than most and discovers that his heritage scares everyone. Mister Nutt also discovers that people can be very adaptable and accepting of someone who tries to make the world better, regardless of what that person’s ancestors might have done (or been made to do).

I must confess that this book is for me one of Pratchett’s better recent Discworld works. I certainly found it a more satisfying read than Going Postal or Making Money.

Posted in Books | Comments Off

Photos of people

As I’m sure anyone who knows me is aware, photography is a hobby of mine (In a way it’s also a form of artistic expression), mostly thanks to my brother Jaap’s inspiration.

So anyway, this weekend the weather was great and I took quite a number of photos. A lot of those photos were at the seaside, since it was such a great place to be. While taking photos as the beach I had a bit of a thought about something…

As a photographer, I record things that catch my eye in time for me to get my camera pointed in the right direction and take the photo. As a heterosexual male, my eye is rather easily caught by attractive women. And here we arrive at a bit of a dilemma, I find it difficult to take pictures of people I don’t know because I always worry a bit that they may object. This means there are many photos I see and never take, because I’m a little weirded out by the thought of taking photos of people I don’t know. There was one lady today I would have loved to have taken an on-the-spot portrait of, she had the most amazing blue eyes, but there’s no way I was just going to walk up to her and ask if I can take her photo. Hell, I even find it difficult to take photos of people I do know without there being some sort of event like a party underway that I’m taking photos of.

So how do I deal with this problem? It is a problem, because I feel I’m missing out of some amazing photographs.

Posted in Random thoughts | Comments Off

Jaap’s photos

One of my main inspirations for getting into photography is my big brother Jaap. He’s been a great photographer for as long as I can remember (I’m too polite now to say just how much older than me he actually is, but he did take some photos of me before I started school).

Some years ago, after a couple of nasty experiences with criminals in South Africa, Jaap packed up his family and emigrated to Canada. I miss them, I miss them a lot, one of these days I must make a plan to take a little trip to Fort Mc Murray, Alberta, Canada. I gotta thank the internet for making it possible for us to still keep in contact and show our photos to each other though, originally WebAperture, now Flickr and Facebook.

Recently Jaap and Trudy went on a trip to the Yukon and posted some really awesome photos.Little green with envy now… ;)

Maybe some day when I’m big I’ll be able to take photos like his.

Posted in Random thoughts | Comments Off

Motorgeeking

Yeah, I’m “Yellow Sports Car Guy”, but that same girl also said it doesn’t count as a sports car because it’s a Mazda. So I thought I’d defend my claim that I drive a sports car that happens to also double up as a potential family car. It’s a 2004 Mazda RX-8 6-speed manual “High Power”.

Firstly, just have a look at what it looks like:

My car

Now let’s have a look at some of the descriptions and facts and figures supporting the sports car claim.

The Wikipedia Article for the Mazda RX-8 summarizes it as “a sports car manufactured by Mazda Motor Corporation”.

Body style is a 4 door quad-coupe.

The layout is a front mid-engine rear wheel drive configuration. This is a pretty important one actually, it’s a mid-mount configuration, the engine is behind the front wheels and the fuel tank is in front of the rear wheels. This gives it a near 50:50 weight distribution, with all the performance handling advantages that come from that.

It has a 1.3 l Renesis naturally aspirated rotary engine that redlines at 9000 rpm. This is a dual 650cc rotor setup that is classed as a 2.6 liter for motor sport classing purposes. Power output is 238 horsepower, which combines with a curb weight for the car of about 1350 kg to produce a car that can do 0 to 100 in 6.4 seconds and has a top speed of 235 km/h.

Weight reduction is a combination of the light rotary engine, light-weight metals for components like the bonnet and rear doors and a carbon fiber composite drive shaft.

It has independent double wishbone suspension in front and independent multi-link suspension in the rear, which combine with a Torsen limited slip differential to make this car a road holder of note. I have yet to feel close to the edge of the envelope going around a corner, it just goes around like it’s on rails.

So I think she’s a sports car, one of many Mazda produced sports cars, such as the very successful RX-7 and the MX-5. As of October 2006 it had won 37 car awards, including the 2004 U.S. Best Sports Car award.

So why do I say it’s also a family car? OK… granted it doesn’t really make a very good family saloon in the luggage space department, but it could still qualify as one.

There are some family car type features that I find interesting.

Firstly, despite the limited size of the interior, the layout of the car does make it entirely possible for four adults to travel long distances in comfort. I have done long-ish roads with three other adults in the car and it’s been fine. The front footwells are very deep, so it’s possible to move the front seats well forward, though for me this results in a slightly uncomfortable driving position.

The interesting rear hinged rear doors make access to the rear seats pretty easy for a sports car, and I feel the fact that they can’t be opened at all while the front doors are closed are an added safety feature for small children in the back on the car.

On the subject of safety, something of importance in a family saloon, this car has a huge number of airbags in it. This combines with a bunch of high technology safety features like ABS and DSC to make this a very safe car to travel in, let’s also not forget about the great road holding. And for those times when you have small children in the back, there are child seat mounting points in the back in addition to the standard belts, there is also a (well hidden) switch to turn rear airbags off because they are dangerous when combined with child seats.

Posted in Random thoughts | 3 Comments