Get all databases last full backup date via PS

Rating: No reviews yet
Downloads: 109
Released: Aug 8, 2012
Updated: Nov 22, 2012 by afarag
Dev status: Stable Help Icon

Recommended Download

Source Code Get-DbBackupStatus
source code, 2K, uploaded Aug 9, 2012 - 109 downloads

Release Notes

Introduction

One of the best practices for maintaining a SharePoint farm is to periodically check and verify that we have daily or weekly (depending on your organization requirements) backups of all of your content databases. If you have a lot of content databases it might be hard to do that manually using SQL Management studio unless you use a script.

Solution

Here we introduce a PowerShell script that will connect to your database server remotely and list all the databases you have access to with their latest full backup date.

How to run the script?

This PowerShell script can be executed from any machine that has PowerShell script support and have access to the Database server. Open the ps1 file and modify the value supplied to the switch "-SQLServer" at the very bottom of the file to point to your SQLServer Instance. Here is an example:
  • global:Get-DbBackupStatus -SQLServer "SQLPROD01\SP_INSTANCE"

Reviews for this release

No reviews yet for this release. (Previous release: 5 stars out of five with 1 rating and 1 review)