Saturday, March 25, 2023

MS-SQL Server - 'I Had' - A Cure

I Had - A Cure


- I had tried to move large backup, but should have made stripping before moving.


- I had tried to create clustered index on existing large table but should have checked enough space to create.


- I had tried to run CheckDB but should have taken maintenance window.


- I had tried to analyse Wait Stats but should have cleared old data a week ago.


- I had taken msdb backup but should have purged old job history before backup.


There may be few other missing 'I Had' please keep visiting this article.


Best Regards


T. Amit Vaid S.


No comments: