Partitioning is a good option, however, is a little more complicated to implement I will suggest using the profiler, move non-cluster indexes to their own file group and drive, and...

http://www.sqlservercentral.com/articles/Security/61678/

This talk about security and will give you everything you need.

You can do this using sqlcmd:

batch file sample:

set servername=SQLInstance,port#

set databasename=sampledb

set tablename=sampletb

sqlcmd -S %servername% -i NameOfScriptFile -o OutputFileName -v db = "%databasename%" tb = "%tablename%"

sqlscript file:

use [$(db)]

select * from $(tb).column

You will...

http://www.sql-server-performance.com/articles/clustering/log_shipping_70_p1.aspx

http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1254458,00.html

Good information hope this help..