MS SQL Server - sp_define_log_shipping

Author

sp_define_log_shipping_monitor

Prabhu

2006-03-05, 8:24 pm

I am getting following error while setting up the log shipping .

Error 2821: Could not find stored procedure
msdb.dbo. sp_define_log_shippi
ng_monitor

When I execute this proc manually using the same account I am using to set
up log shipping , I am was able to run it .

But , I am not sure why I am getting this error while setting up log
shipping using maintenance plan wizard . Obviously , I can't prceed with log
shipping after this error .

I have SQL 2000 SP3 on primary and SP4 on secondary server .

Thanks,
Prabhu

Sreejith G

2006-03-05, 8:24 pm

Only members of the sysadmin fixed server role can execute
sp_define_log_shippi
ng_monitor.

Can you please check if you have enough permission?

--
Thanks,
Sree
[Please specify the version of Sql Server as we can save one thread and time
asking back if its 2000 or 2005]

"Prabhu" wrote:

> I am getting following error while setting up the log shipping .
>
> Error 2821: Could not find stored procedure
> msdb.dbo. sp_define_log_shippi
ng_monitor
>
> When I execute this proc manually using the same account I am using to set
> up log shipping , I am was able to run it .
>
> But , I am not sure why I am getting this error while setting up log
> shipping using maintenance plan wizard . Obviously , I can't prceed with log
> shipping after this error .
>
> I have SQL 2000 SP3 on primary and SP4 on secondary server .
>
> Thanks,
> Prabhu

Prabhu

2006-03-06, 7:16 pm

Yes , I am using an account which is part of sysadmin fixed server role .

Thanks,
Prabhu

"Sreejith G" wrote:
[color=darkred]
> Only members of the sysadmin fixed server role can execute
> sp_define_log_shippi
ng_monitor.
>
> Can you please check if you have enough permission?
>
>
> --
> Thanks,
> Sree
> [Please specify the version of Sql Server as we can save one thread and time
> asking back if its 2000 or 2005]
>
>
>
> "Prabhu" wrote:
>

Sponsored Links