I reviewed it about a year ago: http://www.sqlservercentral.com/columnists/kKellenberger/sqlbackup30.asp .  I thought it performed well. 

I'm surprised that your LiteSpeed backups and restores took longer than native.   We have seen better much performance with LiteSpeed.

I had the network guy check and the port is not blocked internally.  I didn't think it was since other named instances work.

That's a good idea.   I'll think about doing that.  Thought, I might want to write an article about how to get started writing your own scripts and include it as...

Voxinforma:

I use a script to automatically find the lastest full backup, copy the file to a different server and restore the database.  I am using LiteSpeed, so I would need to...

I decided to try this command instead of the script to kill connections:

ALTER DATABASE db_name SET RESTRICTED_USER WITH ROLLBACK IMMEDIATE

That is a good place to start looking. I'll see if I can just exclude this particular database or something.  Thanks for the help.

When you change the default collation of a database, it only affects newly created tables.  There is also a default collation for a table.  Then, the collation is set at...

Sorry, I'm making assumptions that you are using linked forms cause that is where I usually hear about locking problems with linked tables.

I have done this with linked tables.  What I have found is that you SHOULD NOT just link the tables to a form and let the user scroll from row to...

Good advice!

Since becoming a DBA 4 years ago, I haven't really kept up with the VB side of things. I have written only a handful of .Net apps with VB.Net 2003. ...

There is a new book out, see the link in my signature.

Also, what are you trying to accomplish?  If you are just trying to migrate a database over to 2005,...

The book covers migration and storage for sure.  I haven't found security and encryption yet. It might be there, but I haven't read the whole book. I actually wrote two...

Great work, Dale!!!! I'm ordering my copy today.

Kathi