log shipping role change

Last Post 17 Mar 2005 10:21 PM by mgole. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
mgole
New Member
New Member

--
17 Mar 2005 10:21 PM
While doing a log shipping role change, I manually ran the retore job and then i ran the following procedure

USE master
GO
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'hotstandby_sec',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 0,
@keep_replication = 0,
@stopat = null


It gave me the foll error
Server: Msg 22029, Level 16, State 1, Line 0
sqlmaint.exe failed.

The output of sqlmaint.exe is below

NULL
Microsoft (R) SQLMaint Utility (Unicode), Version 8.00.194
Copyright (C) Microsoft Corporation, 1995 - 1998
NULL
USAGE: [-?] | [-S <Server Name>]
[-U <Login ID> [-P <Password>]]
-D <Database Name>
[-Rpt <Output File>]
[-To <Operator Name>]
[-CkDB | -CkDBNoIdx]
[-CkAl | -CkAlNoIdx]
[-CkTxtAl]
[-CkCat]
[-UpdSts]
[-RebldIdx <% Free Space>]
[-BkUpDB <Backup Path>
You are not authorized to post a reply.

Acceptable Use Policy