Blog item

Team, today I want to continue from from previous article. I will talk about the best practices of Virtual Servers and how we can set or utilize our CPUs. I would like us to look at our windows systems and SQL Servers configurations before proceeding with this article. Try and think it through why certain systems […]

When I was a baby DBA, I used to detach and attach but as I becomes strong, I do believe you dont have to stop the SQL Server service to move database files, but you do have to take the specific database offline. This is because you can’t move files while they’re being accessed and […]

Team, I was thinking of a title for this topic but could not find except the above. What I am about explaining in general is how I think we should set SQL Server resources on VMs based on the best practices. I know environments are different but we have similar concepts. In my environment for […]

Methods to Check the last Reboot of SQL Servers and Windows Introduction Being a DBA can be really a thankless job, when everything works fine no one bothers about DBA’s but when things go wrong every one tries to pass the blame on DBA. One of the ideal case is when SQL Server restarts, sysadmin […]

FIX: Log shipping failed due to broken/ damaged tansaction log backup. Log shipping has failed due to incomplete/ damaged transaction log backup. This issue occurred also when there is lack of free space on drive where backups are placed???(no logical explanation). For some reason transaction log backup was saved with errors (damaged) and then transfered […]