No separate transaction log backup job. I understand now you don't require this if log shipping is already setup, as a job is created as part of log shipping and...

Thanks Steve

Well the log backups are taking place as part of the log shipping process. So that will allow a point in time recover. 

I just thought...

ok Thanks Jeffrey for explaining. 

I didn't see it mentioned in this documentation hence was not sure if it was required:

http://mssqllover.blogspot.com/2017/03/step-by-step-configring-windows-fail.html

Thanks Beatrix Kiddo for the replies.

Just one more query related to the 'witness forum' it seems always on is setup /...

Thanks, and for the virtual IP ?

@John Mitchell-245523 - thanks a mill 

So to combine...

@ Sreekanth B - thanks for that. 

Any idea then...

Thanks @gerald72 - Anymore detail on the CMS query or powershell script? I wonder is there one out there anywhere which does similar?

@cyrusbaratt  thanks but this wont work in my situation. There are hundreds of logins to be changed, different logins on different servers and...

@Eirikur Eiriksson print and if command sounds interesting....any idea of how that would look code wise for the following example code?

ALTER...

thanks everyone....

the reason I want to do it this way is the original list comes from excel ....so I want to add back to the excel sheet the...

Great thanks John M, the only issue with that is I have an excel list with 100's of users and I dont want to have to put in a number...

@Eirikur Eiriksson  yes but this wont show the update statement executed and the result for each and every statement?

@Thom A  -  that could well be the issue....for...

I figured it out....using convert datetime works perfect so:

Select @@servername as SQLInstance, name as Login,
LOGINPROPERTY(name, 'PasswordLastSetTime') as PasswordLastSetTime, type, type_desc, is_disabled, create_date, modify_date
from sys.server_principals
where...