Tell Me (and Others)

After seeing Carbonite mentioned on a newsgroup, I thought I would try it. They offer a 15 day free trial. And then US$55 per year to store unlimited backup files on their servers.

I selected a few folders and let it rip. Took about 4 hours to upload my selected folders.

Then it was SUPPOSED to upload any altered files “soon” after they were altered. I had several files that were not uploaded again more that 24 hours later. This is not what they said in their spiel. It says the files will be uploaded whenever the running service detects in-activity on the PC. Well, I left it in-active for a couple of hours and still no upload.

Actually, here is what they say on their site:

When your computer is idle, Carbonite automatically backs up new and changed files. You don’t have to do anything! When you’re using your computer, Carbonite goes to sleep so it will never slow down your computer or internet connection.

I would be loathe to try it again. It is just not for me. But it may well suit someone whose files are not altered too often. If you think you may like it, go ahead. But check that your files are actually being uploaded once changed. The initial upload went very well, but not the uploads about a week into the trial.
I give it a rating of 2 out of five

John Griffiths

UPDATE: 20091005

Chasing down the problem where a changed file is not backed up automatically as advertised by Carbonite, I have found this in their FAQ area…

When Carbonite detects that a file has been modified, it checks to make sure that the file has remained unchanged for 10 minutes before the file is made eligible for backup. (By default, a modified file is backed up only once every 24 hours so that you’ll have the opportunity to restore the previous version if necessary.)

That would be why then! Carbonite goes on to say that i can manually right-click the file and select to force it to “Backup as soon as possible”. That sure conflicts with their sales pitch shown above, where they say:-

When your computer is idle, Carbonite automatically backs up new and changed files. You don’t have to do anything!

So it is not very suitable for situations where an important file (or group of files) are NOT automatically backed up!

For the past ten days, we have been travelling around U.K. with some great friends from Columbia, South Carolina. Astoundingly, the weather was just great the whole time, apart from one day when driving in the very North of England. That day we had periods of light and heavy rain.

The scenery around the Lakes District and North was fabulous. We had a fill of Castles and Churches and Ruins and Gardens.

The worst feature of the whole trip was the airport security checks. These are a farce.

Once I find and unpack my camera, I will post a few photos (or at least some links) here.

John Griffiths

A few weeks ago I ordered an external USB 1 Tb hard drive. This was to replace a 250Gb drive that I use for one of my backup regimes.

It costs less than US$90 and seems a little quicker than my older 250Gb USB drive. This is probably because it is 7,200 RPM in lieu of 5,400 RPM. And I think it has more internal cache memory.

I did not really need the extra room, but perhaps I will one day… The price was right, so why not have more free space available for backups.

Specs of the new drive are: SimpleDrive 1Tb Hitachi HDD.

Backups

Whilst on the subject of backups – I have recently trialed a few simple backup tools that let me schedule backups to remote FTP sites. Two I like are “Backup4All-Pro” and “GFI Backup 2009″

BackUp4All is about $49 and you can get it here

GFI Backup is free, and you can get it here

If you are looking for off-site backup space, you may look at DriveHQ

John

Today we had a birthday party for my 4 year old grand daughter.

We had a bouncy-castle delivered this morning and the guests had a ton of fun jumping for hours. I think they all went home worn out!

If you have a Gateway laptop and it ever fails to boot, then you are pretty much on your own.

I recently tried to get help for a family member who has a Gateway Vista laptop. it is about 3 years old. Now it will not boot. It does not even get through the progress bar on the initial “Gateway” screen. The progress bar stops about half-way.

There are on-screen option… F10 or utilities, F2 for BIOS.

Using the F2, the system start showing BIOS and Processor and memory info. Then locks up.

I tried on-line chat support from Gateway, and then 24Hr email support from Gateway. The common responses were just cut-and-paste sentences from some resource the responder has. In neither attempt (chat with their “expert”, or their email tech responder) were any of the concerns I outlined addressed.

Result = Pay $100 for 30 minutes phone support. This would only result in a wasted phone call. The machine is kaput! Their help sucks BIG-TIME.

Stay away from Gateway products as their support is pretty well non-existent.

It is a sad day when tech support has dwindled to such a low level. Bad Gateway!

It has happened again. An airline pilot has reportedly been removed from flight duty due to security detecting alcohol on his breath.

This makes one wonder how, a person clever and smart enough to have an airline pilot license, could get into such a predicament. It had me wondering until I read a very enlightening and heartfelt post on a pilot’s forum by a pilot who could have got himself into such a predicament. He claims he is/was an alcoholic and details the problem faced by people like himself.

I found reading his post to be valuable in being able to understand the differences in Social drinkers, Problem drinkers and Alcoholics. And it explains just how a Pilot gets into such a predicament.

To read his post, click here

I was doing some extensive software testing in a program that talks to a MS-SQL2005 database. I detected that a table INSERT/UPDATE Trigger was seemingly not firing.

I scrutinised the trigger code and could see nothing wrong, and know that it has been functioning well for several years in other applications, using both MSSQL2000 and MSSQL2005.

So what was different in this program? I searched the web and did not find an answer.

I added some code to a test program to work around the issue. That is when I started catching this error message:

Here I was trying to CALL a stored procedure to update some balances. Again, the stored procedure has been working great for many years with no change. So, what was this message all about? Back to the web again and still no resolution.

That is when I dug deeper and added some more tests into a couple of other test programs I wrote, each of which tried different approaches to see what was really happening.

Strangely, some tested OK with no errors, and others threw the same error! So, what was the difference?

The Answer

The original error it seems is caught by the SQL Native Client ( or perhaps Microsoft Data Access Components (MDAC) ) and translated for the ODBC file drivers I was using. A translation (or miss-translation) is performed and a meaningless message is captured by the ODBC based drivers and passed back to my program as “Executing SQL directly; no cursor”.

Comparing the test programs I was working with pointed me to the answer. It was all to do with permissions! Nothing about “Executing SQL directly; no cursor”.

I found in some programs where I was using Application Role permissions to access the backend SQL, that the Application Role I was using did not have EXECUTE permission on the stored procedure.

Back into MS SQL Server Management Studio I went, and ran this command:

GRANT EXECUTE ON [dbo].[jg_AllBalances11] TO [LMGaus]

Now all my test programs began behaving as expected.

Also, my TRIGGER began working. The trigger was calling the stored procedure to do some of its work, and so now it too performed as expected.

Next time you see the

Executing SQL directly; no cursor

error, check all your permissions!

Hope this helps someone.

John Griffiths

After a great summer DownUnder we are back in Texas for the northern summer. It is already nice and warm here with today around 90°F. Bring on the heat!

The journey was long and tedious as usual. My wife and I are both suffering from Jet-Lag and spend many hours awake at night. We have been waking at about midnight and not getting back to sleep until around 04:00. This should be over within a few more days. Then i will be able to get back and do a few programming tasks that have been piling up!

John