I am new to SQL Server and Power Shell but I have a series of DBA tasks that I need to automate in order to run a certain payment calculation script. The DBA tasks include Database backup, revoking users off the database, killing certain server and DB processes, restoring and allowing users to access the system again.

I would greatly appreciate it, if anyone could let me know what are the best available technologies to do the same.

We are currently running sql server 2000 and looking to upgrade to 2005.