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.
SET @tableHTML = N'<H1>SLX report for activities on ' + @Today + '</H1>' + N'<table border="1">' + N'<tr><th>Account</th><th>Contact Name</th><th>Opportunity Name</th>' + N'<th>Description</th><th>Activity Type</th><th>Notes</th><th>Username</th>' + '</tr>' + CAST ( ( SELECT td = ' ' + [ACCOUNTNAME], '', td = ' ' + [CONTACTNAME], '', td = ' ' + [OPPORTUNITYNAME], '', td = ' ' + [DESCRIPTION], '', td = ' ' + [CATEGORY], '', td = ' ' + [NOTES], '', td = ' ' + [USERNAME] from sysdba.History where CAST(CREATEDATE as Date) = convert(NVARCHAR,GetDate(), 112) FOR XML PATH('tr'), TYPE ) AS NVARCHAR(MAX) ) + N'</table>' ;
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.