I have an application on a client's site that processes data each night, last night SQL Server 2005 gave the error "Could not find stored procedure 'xxxx'". The stored procedure does exist in the database, has the right permission as far as I can tell, the application runs fine in other nights as well.
我在客户端的网站上有一个应用程序每晚处理数据,昨晚SQL Server 2005给出了错误“无法找到存储过程'xxxx'”。存储过程确实存在于数据库中,据我所知有正确的权限,应用程序在其他夜晚运行正常。
In previous occasions, the SQL Server has also gave error saying 'database object not found', and refers to a table in the database that does exists.
在以前的场合,SQL Server也给出了“找不到数据库对象”的错误,并且指的是数据库中存在的表。
So, on rare occasions, the server thinks certain stored procedures and tables does not exist in the database. The objects it refers to are often ones that are frequently used.
因此,在极少数情况下,服务器认为数据库中不存在某些存储过程和表。它所指的对象通常是经常使用的对象。
Is the database somehow corrupted, is there some sort of repair/health check I can do?
数据库是否以某种方式损坏,是否可以进行某种维修/健康检查?
2 个解决方案
#1
I would try using SQL Database Recovery tool (you can download a trial for free) at http://www.mssqldatabaserecovery.com/. It uses high-end scanning mechanisms to ensure in-depth scanning of damaged database and complete data retrieval and it's really easy to use I think. That may be able to tell you what is causing the issues. I know messed up stored procedures have the potential to corrupt your whole database when they go missing or seeminly dissappear like in your case and then it gets ugly.
我会尝试使用SQL数据库恢复工具(您可以免费下载试用版),网址为http://www.mssqldatabaserecovery.com/。它使用高端扫描机制来确保对受损数据库进行深入扫描并完成数据检索,我认为它非常易于使用。这可能会告诉你导致问题的原因。我知道乱七八糟的存储过程有可能在它们丢失时破坏整个数据库,或者像你的情况那样看起来消失然后变得丑陋。
Good luck!
#2
Along with other problems, the client ended up moving to a new server...
连同其他问题,客户端最终转移到新服务器......
#1
I would try using SQL Database Recovery tool (you can download a trial for free) at http://www.mssqldatabaserecovery.com/. It uses high-end scanning mechanisms to ensure in-depth scanning of damaged database and complete data retrieval and it's really easy to use I think. That may be able to tell you what is causing the issues. I know messed up stored procedures have the potential to corrupt your whole database when they go missing or seeminly dissappear like in your case and then it gets ugly.
我会尝试使用SQL数据库恢复工具(您可以免费下载试用版),网址为http://www.mssqldatabaserecovery.com/。它使用高端扫描机制来确保对受损数据库进行深入扫描并完成数据检索,我认为它非常易于使用。这可能会告诉你导致问题的原因。我知道乱七八糟的存储过程有可能在它们丢失时破坏整个数据库,或者像你的情况那样看起来消失然后变得丑陋。
Good luck!
#2
Along with other problems, the client ended up moving to a new server...
连同其他问题,客户端最终转移到新服务器......