you can upgrade the primary to 2016 after removing second node from "always on group".

upgrade the second one and try joining it back with upgraded node 1. this will...

Bala,

user wants to produce the results of below fields

FullName of From User ID | Full Name of To User ID| Serail # |date |

your query will not produce proper results.

take log backup and go for point in time restore on other location to retrieve the data using last full backup and the log backup taken.

thanks, i was wrong

Not like cluster , always on is cluster aware, kindly go through the below link.

https://msdn.microsoft.com/en-us/library/hh882437%28v=sql.120%29.aspx

Hi,

Do you have Db in full recovery?.

do you have log backup?

hope this can help

http://stackoverflow.com/questions/1499885/reportviewer-hide-pdf-export

have you mapped your application user to the created role.

express edition are not meant for production.

SQL 2016 forum is available, post the same there.

In SQL agent there is a alert which can be scheduled to alert after particular size file growth.

additionally restrict the log file to the threshold as per company policy and...

are you connecting through the same connection on both the machines.

by any chance the first user is locked out?

send login details for more clarity.

use sys.dm_exec_query_plan to find the execution counts from restart, the area you asked is performance tuning ot improvement which is a vast area and it will come in experience only....

Does the service account of Agent have access to delete the records from database?

TO DISK = @BackupLoc

your @BackupLoc should return path with file name like "D:\Backup\Saturday\test.bak".

hope this is the error.

On single user mode, were you able to connected to user DB's?.