twitter

Posting tweet...

Using email notifications on DPM 2007 setup with a remote SQL server

There appears to be a bug in DPM 2007 (as of version 2.0.8111.0) where if you have installed DPM 2007 using a remote SQL server you cannot set an SMTP server for DPM to use to send out notifications. Upon trying to set the SQL server for the DPM application (In the DPM 2007 Administrator [...]

Verifying that a file exists with PowerShell

If you use PowerShell a lot, there are going to be times that you need to import data from another file (like a list of servers from a text file to automate a task on many machines). This snippet sets a variable to a file path, tests the files location using the test-path function, and [...]

Scripting de-provisioning of a client in DPM

If you are trying to automate your DPM environment, part of the process is de-provisioning protection groups when a server no longer needs to be backed up. This code snippet will take a clientname input and dpmserver input parameter and remove all data sources (which will effectively remove the protection group) for that client. [...]

How to reboot a machine and wait for it to come back up in Powershell

This bit of powershell code will take a clientname input parameter, immediately reboot the machine, and wait up to 3 minutes for the machine to come back up. After it has been 3 minutes or the machine has come back up, it will display a message depending on the situation.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
param($clientname)
 
shutdown /r /t 0 /m \\$clientname
start-sleep [...]

Problems with Windows system state backups and SQL

It appears there could potentially be issues with VSS when installing SQL on a Windows 2003 server. We had a machine that we were backing up with DPM (which uses, in this case, NTBackup to capture the system state). The machine was backing up fine until SQL Express was installed (I narrowed it down to this [...]