Windows 2003 Server
SQL Server2000
目的: 只有一台机器,要测试log shipping ,所以一台机器上建立了两个实例 。 log_logshippingtest 为primary db上的共享目录 。
问题: 到最后进行数据库备份的时候出现了可能是存取权限的问题, 查询了google ,建议将primary db上的实例test 对应的sql server及
agent 服务中登陆一项更改为SQL user登陆 。 如下图 :
更改重新启动之后,还是不行 。
------------------------------------------------------------------------------------
2008-12-23 08:25:24.65 spid3 Recovery complete.
2008-12-23 08:25:24.65 spid3 SQL global counter collection task is created.
2008-12-23 08:25:26.45 spid51 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.
2008-12-23 08:27:29.68 spid53 Using 'xpstar.dll' version '2000.80.2039' to execute extended stored procedure 'sp_MSgetversion'.
2008-12-23 09:08:46.35 spid53 BackupDiskFile::CreateMedia: Backup device '\\Dcg01\log_logshippingtest\tolywang_test_logshipping_init.bak' failed to create. Operating system error = 5(存取被拒。).
2008-12-23 09:08:46.40 backup BACKUP failed to complete the command BACKUP DATABASE [tolywang_test] TO DISK = N'\\Dcg01\log_logshippingtest\tolywang_test_logshipping_init.bak' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT
2008-12-23 09:17:15.01 spid53 BackupDiskFile::CreateMedia: Backup device '\\Dcg01\log_logshippingtest\tolywang_test_logshipping_init.bak' failed to create. Operating system error = 5(存取被拒。).
2008-12-23 09:17:15.01 backup BACKUP failed to complete the command BACKUP DATABASE [tolywang_test] TO DISK = N'\\Dcg01\log_logshippingtest\tolywang_test_logshipping_init.bak' WITH INIT , NOUNLOAD , NOSKIP , STATS = 10, NOFORMAT

sql_3201.jpg
service_sql.jpg
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-520907/,如需转载,请注明出处,否则将追究法律责任。