Saturday, June 19, 2010

SQL 2000 SP4 Installation Error sp_vupgrade_replication(1)

 

Error

• Msg 170, Level 15, State 1, Server MS, Line 1

Line 1: Incorrect syntax near '-'.

The sqlsp.log file indicates:

Process Exit Code: (0)

Error running script: sp_vupgrade_replication (1)

Action CleanUpInstall:

Installation Failed.

clip_image002

Resolution:
1. Check if distribution database exist though the Replication is dropped
2. If so drop the distribution database
3. To drop the distribution database by over - restoring of some user database
4. Perform the patching / SQL SP again.

7 comments:

馨裕 said...

這麼好的部落格,以後看不到怎麼辦啊!!.................................................................

常映 said...

生存乃是不斷地在內心與靈魂交戰;寫作是坐著審判自己。......................................................................

怡潔怡潔 said...

一棵樹除非在春天開了花,否則難望在秋天結果。....................................................................

婷珊 said...

人有兩眼一舌,是為了觀察倍於說話的緣故。............................................................

芸茂芸茂 said...

成功多屬於那些很快做出決定,卻又不輕易變更的人。而失敗也經常屬於那些很難做出決定,卻又經常變更的人.................................................................

懿綺懿綺 said...

命運,就是自己行為的結果。..................................................

玉苓玉苓 said...

下次再來希望可以看到新的作品喔。............................................................