Windows Forum

Ask something
Discussion Locked

MS SQL 2000

0 helpful
3 replies

by hlittkb

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,got a problem with sql server 2000.
In the process of promoting a standby sql server via sp_change_secondary_role, encountered the following error:
server: msg 22029, level 16, state 1, line 0
sqlmaint.exe failed
appreciate advise how to resolve this?
thanks.

3 replies

by mgonzales

Check and make sure that both servers are running the same service pack. Also make sure your running in from the master db database.

This discussion is closed to new replies.