Exactly... No sysadmin should not grant sysadmin privileges.. A trigger should be prevent while granting sysadmin roles. Iam searching for evevtdata to sent notification like to whom who is trying...

Hi ,

i have verified that, server has build on feb 2009 with sp2 and after sp4 we have applied sp4 recently. model database datafile and log...

Hi George,

perfect,.. it is working fine now .. thanks alot

Hi Gorge,

surprised , now I am finding below error even after reconfigured log shipping by dropping existing subscriber database.

Msg 14412, Level 16, State 1, Line 1

The destination...

Thanks Bhuvnesh,

given link is help full to monitor the log-shipping.:-)

but .. i did not found any error related regarding restoring job... still history...