Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.
SELECT WeekStart = convert(varchar(10),dateadd(week, datediff(week, 0, SU.sessionStart), 0),105),CountID = Count(S.sessionKey) FROM session S INNER JOIN sessionUnit SU on SU.sessionKey= S.sessionKey INNER JOIN product P on p.productKey = S.productKey WHERE SU.instructorKey = 13879 AND convert(DATE,su.sessionStart) >= DateAdd("d",45,getDate()) AND convert(DATE,su.sessionStart) < DateAdd("d",91,getDate()) AND datediff(day, 0, su.sessionStart) % 7 not in (5, 6) and P.productKey=2 and (DATEPART(minute,SU.sessionStart) BETWEEN 840 AND 1440 OR DATEPART(minute, SU.sessionStart) <= 180) GROUP BY dateadd(week, datediff(week, 0, SU.sessionStart), 0) HAVING COUNT(S.sessionKey) >= 2
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
1 Experts available now in Live!