一、殘余數(shù)據(jù) 當(dāng)您進(jìn)行sql server 2000日志傳送的實(shí)驗(yàn)時(shí),也許偶而會(huì)中斷設(shè)定過(guò)程。如果真是如此,那么某些資料仍然會(huì)存入每臺(tái)服務(wù)器的日志傳送資料表,并且影響到后續(xù)的日志傳送設(shè)定動(dòng)作。為了保證這些剩余資料都會(huì)被清除,請(qǐng)確實(shí)刪除每臺(tái)服務(wù)器msdb數(shù)據(jù)庫(kù)內(nèi)日志傳送資料表之相關(guān)資料。
錯(cuò)誤信息: error 14261: the specified primary_server_name.primary_database_name ('n') already exists. error 14426: a log shipping monitor is already defined (...)
microsoft (r) sqlmaint utility (unicode), version logged on to sql server 'ztao-1' as 'ztao-1/administrator' (trusted) starting maintenance plan 'log_plan_9' on 2003-9-4 14:42:02 backup can not be performed on database 'erplogshipping'. this sub task is ignored. deleting old text reports... 0 file(s) deleted. end of maintenance plan 'log_plan_9' on 2003-9-4 14:42:02 sqlmaint.exe process exit code: 1 (failed)