问题现象：
SQL出现问题后重装，U8没有重装，之后直接附加数据库，U8可以正常登陆，但是在备份的时候提示远程组件初始化失败。
问题原因：
因为重装了SQL，没有进行U8数据源初始化，导致Master库中丢失了存储过程储
解决办法：在Master库重建存储过程
USE [master]
GO
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[U8FileServerExtendProc]
@cmdLine [nvarchar](4000),
@Greeting [nvarchar](4000) OUTPUT
WITH EXECUTE AS CALLER
AS
EXTERNAL NAME [U8FileServerExtendProc].[U8FileServerExtendProc.FileServerExtendProc].[DealWithFiles]
GO
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[xp_BackupFiles]
@cmdLine nvarchar(4000) as DECLARE
@return_value int, @strErr nvarchar(4000);
EXECUTE @return_value = dbo.U8FileServerExtendProc @cmdLine,
@strErr output if @return_value=0 begin RAISERROR (@strErr, 16, 1) End
GO
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[xp_UFRegRead]
@root nvarchar(800),
@keyPos nvarchar(2000),
@key nvarchar(800)
as
exec master..xp_regread @root,@keyPos,@key
GO
USE [master]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
create proc [dbo].[xp_UFRegWrite]
@keyPos nvarchar(2000),
@key nvarchar(800),
@value nvarchar(4000)
as
exec master..xp_regwrite 'HKEY_LOCAL_MACHINE',@keyPos,@key,'reg_sz',@value
GO
版权声明：本文为qq37724861原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。