在还原数据库【shù jù kù】🎶的时候🖊出现【chū xiàn】"错误【cuò wù】2812:未能找到存储⚡过程'master.dbo.xp_fileexist'",

分析原因🐕:这是因🐕为某个【wéi mǒu gè】📒出于安【chū yú ān】全考虑【quán kǎo lǜ】把系统扩展存储过程🍄所有的动态连接库都【jiē kù dōu】👎删了【shān le】
通过搜索查询🌙到下面的解决🚹方法【fāng fǎ】

解决方法：1、

把恢复数据库【shù jù kù】🚑需要用【xū yào yòng】到的存👺储过程【chǔ guò chéng】个恢复,打开【dǎ kāi】🍟MSSQL查询分析器,分别运【fèn bié yùn】行下面的两条🛣数据库【shù jù kù】🚑语句即可♊.
EXEC sp_addextendedproc xp_dirtree ,@dllname ='xpstar.dll'
EXEC sp_addextendedproc xp_fileexist ,@dllname ='xpstar.dll'

解决方法：2、 重装SQL2000

SQL server 危险存储过程删除与【shān chú yǔ】😅恢复
删除【shān chú】🦎
use master
exec sp_dropextendedproc 'xp_cmdshell'
exec sp_dropextendedproc 'xp_dirtree'
exec sp_dropextendedproc 'xp_enumgroups'
exec sp_dropextendedproc 'xp_fixeddrives'
exec sp_dropextendedproc 'xp_loginconfig'
exec sp_dropextendedproc 'xp_enumerrorlogs'
exec sp_dropextendedproc 'xp_getfiledetails'
exec sp_dropextendedproc 'Sp_OACreate'
exec sp_dropextendedproc 'Sp_OADestroy'
exec sp_dropextendedproc 'Sp_OAGetErrorInfo'
exec sp_dropextendedproc 'Sp_OAGetProperty'
exec sp_dropextendedproc 'Sp_OAMethod'
exec sp_dropextendedproc 'Sp_OASetProperty'
exec sp_dropextendedproc 'Sp_OAStop'
exec sp_dropextendedproc 'Xp_regaddmultistring'
exec sp_dropextendedproc 'Xp_regdeletekey'
exec sp_dropextendedproc 'Xp_regdeletevalue'
exec sp_dropextendedproc 'Xp_regenumvalues'
exec sp_dropextendedproc 'Xp_regread'
exec sp_dropextendedproc 'Xp_regremovemultistring'
exec sp_dropextendedproc 'Xp_regwrite'
drop procedure sp_makewebtask
go

恢复
use master
exec sp_addextendedproc xp_cmdshell,'xp_cmdshell.dll'
exec sp_addextendedproc xp_dirtree,'xpstar.dll'
exec sp_addextendedproc xp_enumgroups,'xplog70.dll'
exec sp_addextendedproc xp_fixeddrives,'xpstar.dll'
exec sp_addextendedproc xp_loginconfig,'xplog70.dll'
exec sp_addextendedproc xp_enumerrorlogs,'xpstar.dll'
exec sp_addextendedproc xp_getfiledetails,'xpstar.dll'
exec sp_addextendedproc sp_OACreate,'odsole70.dll'
exec sp_addextendedproc sp_OADestroy,'odsole70.dll'
exec sp_addextendedproc sp_OAGetErrorInfo,'odsole70.dll'
exec sp_addextendedproc sp_OAGetProperty,'odsole70.dll'
exec sp_addextendedproc sp_OAMethod,'odsole70.dll'
exec sp_addextendedproc sp_OASetProperty,'odsole70.dll'
exec sp_addextendedproc sp_OAStop,'odsole70.dll'
exec sp_addextendedproc xp_regaddmultistring,'xpstar.dll'
exec sp_addextendedproc xp_regdeletekey,'xpstar.dll'
exec sp_addextendedproc xp_regdeletevalue,'xpstar.dll'
exec sp_addextendedproc xp_regenumvalues,'xpstar.dll'
exec sp_addextendedproc xp_regread,'xpstar.dll'
exec sp_addextendedproc xp_regremovemultistring,'xpstar.dll'
exec sp_addextendedproc xp_regwrite,'xpstar.dll'
如果经【rú guǒ jīng】过以上手段还🐋不可以的话【de huà】💝，我教你【wǒ jiāo nǐ】一个绝🐵对可以的方法。

就⏫是在选【shì zài xuǎn】择还🦊原设备🏮的时候直接把你的备份数据【fèn shù jù】🥌库的文件的路【jiàn de lù】径填进【jìng tián jìn】去💵,点确定【diǎn què dìng】点确定【diǎn què dìng】后还是"错误2812:未能找到存储【dào cún chǔ】过程'master.dbo.xp_fileexist'",这时候你直接点这个【diǎn zhè gè】🎱错误对话框的确定按💋钮即可【niǔ jí kě】，然后选【rán hòu xuǎn】择：强制还🍓原数据【jù】🛋库,点开始【diǎn kāi shǐ】还原数据【jù】🛋库 等一会📌就⏫OK了【le】🐡