SQL2000下，Logshipping的Copy任务没有报错，但是却没有把相应的日志备份文件拷贝到备点。这是怎么回事？

Question

在备点查询表msdb.dbo.log_shipping_plans得到：
source_dir 的值：\\W231\BackupShare
destination_dir 的值：E:\BackupCopy
主点服务器W231和备点服务器W232的Administrator用户密码相同，主点实例 W231\MAIN 和备点实例 W232\OTHER 的sa密码相同。

在备点的服务器上，看到的现象：路径\\W231\BackupShare下不断地生成TLOG文件，但是文件夹E:\BackupCopy中一个文件也没过来。

这是怎么回事呢？

Answer 1

Do you start sql agent service with domain account? That account needs permission to read remote files.

Answer 2

Yes, I have changed the sqlagent start account to "./Administrator", and I have open the folder \\W231\BackupShare by this user in Explorer. But, I can not see any copied file in the local folder 'E:\BackupCopy' when the copy-job's history records display:

执行用户: W232\Administrator。output                                                                                                                                                                                                                                                        
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(null)
Microsoft (R) SQLMaint 实用工具（Unicode），版本 8.00.760                                                                                                                                                                                                     
版权所有 (C) Microsoft Corporation, 1995 - 1998.  步骤成功。

Answer 3

"./Administrator" is not domain account, and sql agent service account needs permission to access remote folder.

Answer 4

我在SQLAGENT的启动账户属性对话框的“本账户”中输入了"W232\Administrator"，是系统自动修改为了".\Administrator"。

对不起，是我刚才输入斜杠时敲反了。

Answer 5

It's local account, can't access remote folder.

Answer 6

Ok. If the user 'Administrator' is a local account, then which user is domain account or How can I get it ?

Here are users in the server W232:
Administrator
Guest
IUSR_W232
IWAM_W232
SQLDebugger
SUPPORT_388945A0

Here are groups in the server W232:
Administrators
Backup Operators
Distributed COM Users
Guests
Network Configuration Operators
Performance Log Users
Performance Monitor Users
Power Users
Print Operators
Remote Desktop Users
Replicator
Users
HelpServicesGroup
IIS_WPG
OLAP Administrators
TelnetClients

Answer 7

那意思是不是说，配置SQL2000的Logshipping时，一定要在域的环境下，使用域用户来启动SQLAgent，才能访问主点服务器的共享文件夹\\W231\BackupShare ？如果不在域环境下，就不能做到了吗？我在配置SQL2005的Logshipping时，就是不在域环境下完成的啊。

Answer 8

Point is that sql agent service account needs permission to access remote share, you can copy whatever process you did on sql2k5 to sql2k.

Answer 9

经过反复测试，在重新搭建的环境中，Copy任务可以拷贝日志备份文件了，文件夹'E:\BackupCopy' 中看到结果，更重要的，此时并未加入AD。。。。