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?.

I too go with Min - Max memory setting

for 3rd point i told to set page file manually on seperate drive where SQL or OS file should not present.

if your...

1) I dont have much idea on sepearate drives but keeping it on seperate drive will improve performance

2) For Physical Memory 1 TB - Max you can set 1.5 TB

3)...