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.
UPDATE newseason SET YearNumber = left(@SeasonNumber,4), YearName = left(@SeasonNumber,4), SeasonNumber = @SeasonNumber, SeasonNumber1 = @SeasonNumber, SeasonName = @SeasonName, MonthNumber = left(@SeasonNumber,4) + '0' + left(CONVERT(CHAR(8),TID,10),2), MonthName = DATENAME(MONTH,TID) , WeekName = REPLACE(('Week of ' + left(CONVERT(CHAR(8),TID,10),2) + '/' + substring(CONVERT(CHAR(8),(SELECT DATEADD(wk, DATEDIFF(wk,0,TID), 0)),10),4,2) + '/' + cast(Year(TID) as varchar)),'Week of 0','Week of '), WeekNumber = cast(Year(TID) as varchar) + '00' + cast(DATEDIFF(week, @FiscalYear, TID-1) as varchar)+1, DayNumber = cast(Year(TID) as varchar) + '0' + cast(DATEDIFF(day, @FiscalYear, TID+1) as varchar), DayName = (SELECT DATENAME(dw, TID))
|kill process lock Sql server||9||46|
|SQL Server - Find Parent/Child relationship tree between numeric range.||7||40|
|Why Delete * statement wont work with sql server ?||6||38|
|SQL Server: Unable to remove duplicate sets in Header/Detail||6||22|