You might want to read Ken Hendersons "The Guru's Guide to SQL Server Architecture and Internals", just starting that myself.

Brave thought Jay...BUT

When a former child molester moves in next door, you DO change your way of life by watching your children more closely, you might stop walking down the...

set @Command = ('"C:\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a SERVname f:\OLAP\data\ CUBEname \\backup\dbremotebackups\SERVname_CUBEname.cab \\backup\dbremotebackups3\SERVname_CUBEname.log')

will do the trick.

I get it now: Sean Mc Clown!  Yea, I've heard about him!  Funny white guy?  Yes I suppose he's white....  Geoge Costanza.

Steven D

I was just thinking, when Sean is thrown into the lake of fire, which is never quenched, I wonder if he'll be thinking, he should have cursed less and "PTL'd" a...

It looks like the SQL statement optimizer is different in 64 bit vs 32 bit.   Perhaps a call to Bill Gates will result in a fix?  I think it's 1-800-call-bill!

Would it make sense to have each "step" as a seperate step via one SQL Agent Job, that way you can setup "on failure" process to stop for each step?

Just installed and ran last week, had to install NET 1.1 and it's Windows upgrades to get it to work.  IE 6.0 in use and saw no issues with it. ...

Within a new SQL Agent Job, create the actual backup statement naming the backup, nothing should be appended to it then.

Try using a differential instead of the Tlog backup.