问题现象:
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_va