I'm not entirely sure why you are wanting constant recording as you'll need lots of high capacity drives to store that much footage which you'll need to keep swapping out. Perhaps a better solution is to use software that will record footage when it detects motion, this way you won't have hours of recording when nothing is happening. (I'm just working off the assumption this is some kind of home/personal cctv setup you are looking for).
In which case there are two free/open source apps you may want to consider. The first is
iSpy which works with Windows machines and the second is
ZoneMinder which is for Linux machines. Also found a handy
setup guide for ZoneMinder.
As for the hard drive, I believe the largest available drives are currently 6TB. The version of SATA doesn't really matter too much as they are backwards compatible, i.e you can plug a SATA 3 drive into a SATA 2 port. The only difference is the speed (backwards compatibility throttles speed). SATA 2 runs at a maximum of 3gb/s whilst SATA 3 runs at a maximum of 6gb/s.