Last year, I started writing an article that was supposed to be a series for Installing, Configuring and Managing Windows Server Failover Cluster using Windows PowerShell. The first of the series came out on July 2013 (which ended up being the last article I wrote for the year 2013 on MSSQLTips.com.) Since then, I’ve been involved […]
PostRetrieve Default SQL Server Backup Folder using PowerShell
As I’ve been translating a lot of my TSQL script to Windows PowerShell with SMO, here’s another articleI wrote on how to check for the default SQL Server backup folder
PostCheck the last backup date in SQL Server using Windows PowerShell
This article highlights how to use Windows PowerShell to retrieve database properties using SMO. Notice how easy it is to check the database properties using pretty common syntax One of the challenges I have when I was starting out as a SQL Server DBA was to check for the last backup date for a database. […]
