数据库为什么会置疑?有什么条件会产生这个原因?

来源:百度知道 编辑:UC知道 时间:2024/06/08 17:16:08
如题

1 SQL Server所在分区空间是否够?数据库文件大小是否达到最大文件限制?

2 数据库文件损坏或被非正常删除时出现这种情况

3 病毒防火墙的扫描也会引起数据库置疑

INF: Consideration for a virus scanner on a computer that is running SQL Server 2000
http://support.microsoft.com/default.aspx?scid=kb;en-us;309422

If the virus sweep has opened a database file and still has it open when SQL Server tries to open the database (such as when SQL Server starts or when SQL Server opens a database that AutoClose has closed), the database to which the file belongs might be marked suspect. The SQL Server database files typically have the .mdf, .ldf, and .ndf file suffixes.

4 当SQL Server启动时,将会尝试获得对数据库文件的排他访问权,如果此时该文件被其他程