Monthly Archives: August 2017

Multi-server Script to Find Orphaned Data Files using PowerShell

Posted on August 23, 2017 by Prashanth Jayaram

In this article, we take the sledgehammer approach in searching for MDFs and then comparing them against files which are available on the listed drive. The idea behind this is to generate a report of detached database files across multiple … Continue reading →

Planning a SQL Server Backup and Restore strategy in a multi-server environment using PowerShell and T-SQL

Posted on August 15, 2017 by Prashanth Jayaram

This post demonstrates one of the ways to gather an inventory of database backup information. The output of the script includes various columns that show the internals of a database, backup size, and gives the latest completion statuses and the … Continue reading →

Posted in SQL, SQL Server Backup | Tagged import SQL Server module, Remove-Module SQLPS, SQL Server backup and Restore strategy, Write-SqlTableData, Write-SqlTableData examples | Leave a comment

A Quick Start Guide to Managing SQL Server 2017 on CentOS/RHEL Using the SSH Protocol

Posted on August 8, 2017 by Prashanth Jayaram

This article details the following How to get PuTTY and SQL Server How to install/uninstall SQL 2017 CTP2.1 How to Upgrade to SQL 2017 RC1 How to Install/remove SQL Tools In one of my previous articles Installation of SQL Server vNext … Continue reading →