That's a very complicated question these days. I prefer Quest LiteSpeed, but the other major players are Red-Gate SQL Backup, and Hyperbac.

They've all got their strengths, but you...

Y, if the login isn't a local admin and you don't have builtin\admins specified in SQL, then you won't be able to connect. Just being a windows acct, or...

Y, that paging you're seeing is SQL contending with other things on the box as they need to load and unload RAM. If you're running SQL, file, and backup...

Even if you pregrow your files you'll still get fragmented unless they're all on separate disks. It's impossible not to because if you ever add a file it'll come...

oh, you're not the original poster... Fine... sorry then.

No, i'm not sensitive because it's friday... I've got this huge hemorrhoid, and nobdy will look at it for me.

Perhaps the agent acct doesn't have the rights you think it does. Try running the job as a specific user.

That's kind of a new one on me man.

It sounds like he's clearly connected to the DB though. Maybe a bad install of SSMS?

I've come across a couple sps that the procs on the net couldn't decrypt, but I haven't figured out what the key is yet.

But in general, no, they can always...

I'm sorry, it looks like you don't need my help because you've got it all figured out.

I was talking theory to help you narrow down your decision, which is what...

Perfmon data can be difficult.

Look at

Memory\availableMB to tell you how much memory you have left.

PHysicalDisk\avg. disk queue length to ovbiously tell you if you're disks are over-worked.

System\cpu queue to...

That's because Yukon has tighter security than Shiloh.

Have you created a proxy and given it rights to active-x? That may get you what you're after.

I just brought up a Win08 box but I'm still using Yukon.

The only thing I can think of that would keep you from being able to do this...

There's not specifically a builtin script for it, but feel free to write it yourself. It doesn't sound like it should be that difficult. Just off the top...

I concur. Full backups don't touch the LSNs.

He's right. The LS help file gives detailed directions on this topic. However, another good method is to convert the file back to native format, which the LS...