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.
(case i.add_3 when 'Co Londonderry' then i.add_2 when 'Co Antrim' then i.add_2 when 'County Londonderry' then i.add_2 when 'Co Tyrone' then i.add_2 when 'Co Derry' then i.add_2 -- when isnull(i.add_3,i.add_2) -- this line is incorrect else i.add_3 end) as 'town',
|SQL Server 2005 - reduce database/logfile size on system that is running out of disk space||36||42|
|MS SQL 2005 Srink database in chunks||4||58|
|insert query with value having 's||2||51|
|Error in SSIS while executing - Potential data loss||4||23|