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

Advertisements

Developer @ SQL Server Team, Microsoft

Posted in Backup, Powershell, SQL Power shell, SQL Server
2 comments on “SQL 2008 Power Shell script – Databases that were not backed up in last 7 days
  1. vik says:

    Hi Sethu…is there any chance…Im sheduling the task through shedule task in windows from one server to different server…database…
    its not working for me….could u pls reply …how can i give database name….in $dbname field…im confused

  2. ram says:

    Im talking about rebuilding index using powershell script …..if possible wats the best way to do it……task sheduler is in different server…and db is different server…and wats the format for giving db name in database name field

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: