Can ms sql MDF file's contain virus's?

MDF files as such cannot contain virus. But data which is stored in the tables can contain virus in the form of encrypted javascript or iframe both referencing download of malware on the clients pc accessing the data. It is the result of SQL Injection attacks. Apart from that mdf file cannot contain virus.

Regards

Robert Sharon

In theory one could store a virus-laden file in your DB, in which case it'd end up in your MDF file.  However this would not been the MDF becomes "contagious", because it's not an executable file.  One would need to read the file from the DB, write it to disk (at which point your machine's virus scanner should pick it up anyhow), and then you'd need to execute it.

I'd say the risk of this is very very low.  However virus-scanning the MDF file is an easy and nil-effort thing to do, so why not simply scan the file and make sure?

--

Adam

Cheers people, I'm on SQL server.

Do you perchance mean "MS ACCESS MDF Files"?  As far as I am aware, MS SQL does not use "MDF" files.

Anyway as to viruses, Microsoft Access supports Visual Basic modules and viruses can be written in Visual Basic, so I presume Yes, a MDF file can contain a virus.

How you clean it.... Don't use MS Access for something it is not designed for, even Microsoft recommends not to use Access for Internet applications.

Other then that, I can only suggest asking your question on a Access support channel will probably provide better answers.