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 orderheader.orderno, companyname, jobheader.jobdesc, section.title, orderheader.coverpagination, orderheader.textpagination, section.depth, section.width, sourcingbrands.branddesc, section.papertype, orderheader.completedate, CASE WHEN iscover = 1 THEN papergsm else '0' END AS [cover weight], CASE WHEN iscover = 0 THEN papergsm else '0' END AS [text weight] from section inner join orderheader on section.orderno = orderheader.orderno inner join customers.dbo.company on orderheader.customer = customers.dbo.company.coid inner join jobheader on orderheader.orderno = jobheader.orderno inner join binding on jobheader.orderno = binding.orderno inner join sourcingrequest on jobheader.jobno = sourcingrequest.jobno left outer join sourcingrequestxref on sourcingrequest.sourcingid = sourcingrequestxref.sourcingid left outer join sourcingpapermaster on sourcingrequestxref.paperid = sourcingpapermaster.paperid left outer join sourcingbrands on sourcingpapermaster.pbid = sourcingbrands.brandid where section.recordtype = 'ppe' and binding.recordtype = 'ppe' and orderheader.completedate > '2008-01-01' and binding.description not like '%guillotine%' and binding.description not like '%folder%' and binding.description not like '%sitma%'and binding.description not like '%pre stitch%' and jobheader.jobno = '7005' order by orderheader.completedate
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.