Archive

Posts Tagged ‘powershell for’

PowerShell V3 What’s New?

February 15, 2013 3 comments

In this article I’m going to list some of the notable features introduced in PowerShell V3.0

  • WorkFlows

PowerShell V3 introduces Windows PowerShell Workflow (PSWF), which helps automate the distribution, orchestration, and completion of multi-computer tasks, freeing users and administrators to focus on higher-level tasks. PSWF leverages Windows Workflow Foundation 4.0 for the declarative framework, but using familiar PowerShell syntax and constructs. Read more…

Categories: Powershell Tags: ,

PowerShell Script to Send Email (multiple recipients)

February 15, 2013 14 comments

In this article I will try to wrap how to PowerShell to manage your SQL Server Notifications. And this is very much regular scenario for most of the SQL Server DBA’s to generate notifications when issues arise. There are many ways that we can handle these notifications, but one of the simplest and most reliable and the most common way is email notifications. Read more…

PowerShell script to backup a database and restore on other server.

December 16, 2012 18 comments

Many a times as a DBA when we need to refresh our QA or Dev environment with Production environment, we need to have a full backup of Production database and then manually we need to restore them in other environments. The following is  a simple power shell script to just take a full backup with copy only option and then restore it on other server. Read more…

Powershell – Powershell Script to backup all user DBs in SQL Server

Powershell is Microsoft’s task automation framework.

The following is a simple powershell script to take full backup of all users database of MS SQL Server, this script is tested on MS SQL Server 2008R2 and MS SQL Server 2012(Denali). Read more…

%d bloggers like this: