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 c.id AS ContactID, CASE c.middlename WHEN NULL THEN c.firstname + ' ' + c.lastname + '' ELSE c.firstname + ' ' + c.middlename + ' ' + c.lastname + '' END AS FullName, CASE c.phone2 WHEN NULL THEN c.phone1 + ' | ' + c.phone2 ELSE c.phone1 END AS Phone, c.email, co.name AS Company, CASE WHEN cu.date_assigned IS NULL THEN lstatus.description + '-Not Assigned' ELSE lstatus.description + '-Assigned' END AS Status, CASE WHEN cu.date_assigned IS NULL THEN DATEDIFF(dd, cu.date_created, getdate()) ELSE DATEDIFF(dd, cu.date_assigned, getdate()) END AS DaysElapsed FROM contacts c INNER JOIN lookups lstatus ON lstatus.id = c.status INNER JOIN contacts_users cu ON cu.contact_id = c.id AND cu.active = 1 INNER JOIN users_locations ul on ul.user_id = cu.user_id INNER JOIN locations l on l.id = ul.location_id AND l.active = 1 INNER JOIN companies co on co.id = l.company_id AND co.active = 1 ORDER BY c.id
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.