I have few log shipping jobs failed the reason is, see error:
RESTORE LOG is terminating abnormally. [SQLSTATE 42000] (Error 3013) Cannot open backup device 'X:\abc-logbackup\tlog201010292205.TRN'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201). The step failed.
I checked standby server, it is running fine. any solution?
Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below:
PERCENT_RANK() function will returns the percentage value of rank of the values among its group.
PERCENT_RANK() function value always in be…