|
hi to all, i am new to DBA. my question is can virus affect the sql server installed files or data files or cause changes in the databases. i need your suggestions if it is yes... and also suggest me what should i do if these things happen. please explain how can i manage anti-virus for sql server. and please share if you face any issues related to virus issues or anti-virus management... Thanks in advance... ,
(comments are locked)
|
|
I have not seen a virus that directly affects SQL Server executables or the storage files, no. Most of the viruses and hacking in and around SQL Server are geared towards getting access to your data to either destroy it outright or steal it. You need to worry about viruses, but primarily only for the operating system. The main concern for SQL Server is security. The biggest security hole that you see around are SQL Insertion attacks. People can take advantage of poorly constructed code to hack into the system. If you want an example, look up the phrase "little Bobby Tables". Aah the classic bobby tables!
Aug 20 '12 at 10:41 AM
sp_lock
(comments are locked)
|
|
Thank you so much for your suggestions. it clear my doubts and it drives me to know about sql injection attacks. Thanks for the support.
(comments are locked)
|
|
Im not sure of a current SQL server virus. In the pass there as been the slammer virus but that was nearly 10 years ago. Thats not to say the next one isn't around the corner. From a installation of a AV then I would suggest installing the AV but with the following exclusions.
See here for further docs, as it includes other processes that you may wish to exclude. Some also don't like to install an AV on the SQL server, but this can be risky (IMO), especially if you don't control the infrastructure.
(comments are locked)
|
|
It is difficult for a virus to effect data files as they are exclusively locked by the SQL Server process during operations.
(comments are locked)
|
