Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mgole
Starting Member
9 Posts |
 Posted - 2005-03-18 : 02:15:24
|
| While doing a log shipping role change, I have manullay run the retore job and then i ran the following procedureUSE 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 errorServer: Msg 22029, Level 16, State 1, Line 0sqlmaint.exe failed.The output of sqlmaint.exe is below NULLMicrosoft (R) SQLMaint Utility (Unicode), Version 8.00.194 Copyright (C) Microsoft Corporation, 1995 - 1998 NULLUSAGE: [-?] | [-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> | -BkUpLog <Backup Path>] [-BkUpOnlyIfClean] [-BkUpMedia DISK [-DelBkUps <time period>] | TAPE] [-UpdOptiStats <% of Database to Sample>] [-HtmlRpt <Html File>] [-VrfyBackup] [-RmUnusedSpace <Minimum DB in MB> <% of free space to leave>] [-PlanID <GUID identifying the maintenance plan in 36 character hex format>] [-PlanName <Maintenance plan name>] [-CrBkSubDir] Create a sub-directory (for storing backup files) for the database(s). [-UseDefDir] Use the default backup directory. [-WriteHistory] Write history to msdb.dbo.sysdbmaintplan_history. [-DelTxtRpt <time period>] Delete text reports older than given time period Please let me know how to resolve this error.Madhukar |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-03-18 : 13:36:55
|
| Don't you just love how descriptive sqlmaint.exe is? I have never been able to get the role change to work. Any time we need to it, we recover the database at the DR site, then setup log shipping again to the primary site.Tara |
 |
|
|
|
|
|
|
|
Log shipping role change