I hope some really cool experts can share their knowledge with me.
We have a dedicated server to host our online store
- Runs SQL 2005
- No uploading by web viewers, strictly to sell goods
- Server hosts a secure payment page for credit card processing. We don’t store card data
- Subsequently, Server needs to be PCI-compliant
- No mail server function or FTP
- Server not connected to any other servers or PC
Questions:
- Do I need anti-virus, firewall or other software?
- If yes, can anyone recommend one?
- How do I backup server?
- In addition, I have a programmer who has user account in the server. How do I setup security policy so that he does not take away company data in database? He tweaks DB code every now and then.
Thanks a lot for the time and for every kind soul who attempted to answer these questions. Merry Christmas
Answer
Do I need anti-virus, firewall or other software?
Yes
If yes, can anyone recommend one?
No. that is a shopping question.
How do I backup server?
Seriously? You run a backup program like ntbackup or something else you buy saveing the results to some form of remote/removeable media. The are entire books on this subject.
In addition, I have a programmer who has user account in the server. How do I setup security policy so that he does not take away company data in database? He tweaks DB code every now and then.
Setup a dev server for him. Don’t give him direct access to the production database.
Attribution
Source : Link , Question Author : Joseph Burnett , Answer Author :
2 revs