no i did not tried  with that  option . i am assuming  to take backup  from primary  and restore  with no recovery  and add the db  back to AG ....

No I don't want  to remove  and re add the  database on AG in primary. I need a query to check the last log backup restored on secondary  replica as...

Thanks for the  suggestion and reply ,  please  provide  the query   as  i am not proficient in programming

When i viewed  the reports   data is not updated  properly , and coming  incorrectly .  how to referesh  in logshipping  to update the  data in both primary and  secondary  servers...

any suggestions on this is helpful..

The backup file name like  database_yyyymmdd.bak  .

We are  using the sql agent job  to take the local drive backup of all the databases   on the source and having sufficient permissions on the destination server .xp_CmdShell is...

SQL Edition is enterprise and version should be 2012.

No i am not using any CMS,  needs to configure on servers

i need to get the stored procedure details which are using xp_cmdshell  on all databases

Thanks  for the help ...

Do i need to execute the stored procedure  query on individual databases or in master db

i have  50+ jobs in my server its not possible to go each step in job  and see  whether it is enabled or not , is any alternative way to...

i dont have any db monitoring in place ,  i need to configure alert of t-log utilisation exceeds the limit  of all servers in one server .i.e on central server...

It will  give report when specific service is in stopped state   ,

Get-ServiceSQLAlert -ComputerList C:\ file .txt -includeService "", -To  -From  -SMTPMail

also it will not give correct data  for cluster servers...

Thanks for the reply i used the below script

Function Get-ServiceSQLAlert

{

param(

[String]$ComputerList,[String[]]$includeService,[String]$To,[String]$From,[string]$SMTPMail

)

$script:list = $ComputerList

#Make sure to check write acess on c:\ drive. if not, change the path

$ServiceFileName= "c:\ServiceFileName.htm"

New-Item -ItemType file $ServiceFilename -Force

#...