Blog Archives

Index rebuild on large database – SQL Agent Powershell job


Index rebuild on a large database could take longer time. One of our customer was looking for a solution to rebuild index one by one  when index  fragmentation is greater than 30%.  Related  newsgroup thread: http://social.msdn.microsoft.com/Forums/en-US/sqlkjmanageability/thread/4faae7c8-3e58-4117-8538-f397e342743f In this blog post, I have

Posted in DB Management, Powershell, SQL Agent, SQL Power shell, SQL Server

SQL 2008 Power Shell script – Databases that were not backed up in last 7 days


Here is a simple powershell command to list databases that were not backed up in last 7 days. http://blogs.msdn.com/b/sethus/archive/2008/06/10/sql-2008-power-shell-script-databases-that-were-not-backed-up-in-last-7-days.aspx

Posted in Backup, Powershell, SQL Power shell, SQL Server