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.
use dictionary insert into dbo.TblCurrentWordCounts (WordStat_ID, Word, NoOfWords, WordLength, WordPosition, ClientCode, MyDateTimeCol,ClientCodeWordPosition, ClientCodeWordWordCountWordLenPosition) select Word + CONVERT(CHAR(17),GETDATE(),120) AS CurrentDateTime, GETDATE() AS MyDateTimeColWord, Word, NoOfWords, wordlen, WordPosition, ClientCode, ClientCode & '_'& word &'_'& WordPosition, ClientCode & '_ '& word &'_ '& NoOfWords &'_ '& WordLen &'_ '& WordPosition from TblWords where word <>'' and clientcode='210904C' --where word <>'' group by word, NoOfWords, ClientCode, wordlen, WordPosition order by clientcode
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Load Fact table in SQL Server SSIS package||14||45|
|Backing up Large SQL Server VM Best practice [using Veeam Backup]||8||74|
|SQL Server Reports (SSRS 2014) - Reports Timing Out||11||116|
|Importing from CSV to SSMS||2||7|
Join the community of 500,000 technology professionals and ask your questions.