Video Archiving Tool
Based on research I did for a client here's what I found out. 


Canto Cumulus is a desktop app that has a good rep but is relatively
expensive.
iDive is a Mac based app that is relatively cheap but may
not have everything you need or want. 
Imagine Products has some good
integrated solutions. I've used their ShotPut Pro software. Their
customer service is very good.
I've purchased and implemented CatDV.
It is simple and has a number of automation features. Basically drag
and drop.


You didn't mention platform. I'm on Apple so my solutions are Mac-centric.