Messaging….. Technology…… Life…..

Well not many more entrants that came out of the woodwork….

Bharat Suneja posted a nice entry since the last call….

But the winner is Nick Smith!! who posted this handy dandy little script to the comments of the original post.

Jeffrey, I heard Bruce’s book is almost done, will you be able to get Nick a copy still?

1. Here is a script to dynamically detect all databases on an Exchange 2007 server and backup each database with ntbackup.

   function perform_backup ([string] $ServerName, [string] $BackupRootDrive) {
   $BackupScriptPath = $BackupRootDrive + “BackupScripts\”
   $BackupPath = $BackupRootDrive + “DailyBackups\”

   $BackupScript = $BackupScriptPath + $ServerName + “BackupScript.bat”
   $BackupLog = $BackupScriptPath + “ExchangeBackupLogs.log”
   new-item $BackupScript -type file -force
   new-item $BackupLog -type file -force

   Add-Content $BackupScript “@ECHO off”
   #Add registry keys to improve ntbackup performance
   #See http://www.microsoft.com/technet/itsolutions/msit/operations/exchbkup.mspx
   Add-Content $BackupScript “reg add `”HKCU\Software\Microsoft\Ntbackup\Backup Engine`” /v `”Logical Disk Buffer Size`” /t REG_SZ /d 64 /f”
   Add-Content $BackupScript “reg add `”HKCU\Software\Microsoft\Ntbackup\Backup Engine`” /v `”Max Buffer Size`” /t REG_SZ /d 1024 /f”
   Add-Content $BackupScript “reg add `”HKCU\Software\Microsoft\Ntbackup\Backup Engine`” /v `”Max Num Tape Buffers`” /t REG_SZ /d 16 /f”

   Get-MailboxDatabase | where {$_.ServerName -eq $ServerName} | foreach{
   $JetBackupSyntax = “JET ” + $_.ServerName + “\Microsoft Information Store\” + $_.StorageGroupName + “\” + $_.AdminDisplayName
   $BksFileName = $BackupScriptPath + $_.ServerName + “” + $_.StorageGroupName + “” + $_.AdminDisplayName + “.bks”
   $JetBackupSyntax | out-file -filepath $BksFileName -encoding unicode
   Add-Content $BksFileName “”
   $BksDescriptiveName = $_.ServerName + “_” + $_.StorageGroupName + “_” + $_.AdminDisplayName
   $NTBackupLine = “C:\WINDOWS\system32\ntbackup.exe backup `”@” + $BksFileName + “`” /n `”” + $BksDescriptiveName + “`” /d `”” + $BksDescriptiveName + “`” /v:no /r:no /rs:no /hc:off /m normal /fu /j `”” + $BksDescriptiveName + “`” /l:s /f `”” + $BackupPath + $BksDescriptiveName + “.bkf`” ”
   Add-Content $BackupScript $NTBackupLine
   }
   Get-PublicFolderDatabase | where {$_.ServerName -eq $ServerName} | foreach{
   $JetBackupSyntax = “JET ” + $_.ServerName + “\Microsoft Information Store\” + $_.StorageGroupName + “\” + $_.AdminDisplayName
   $BksFileName = $BackupScriptPath + $_.ServerName + “” + $_.StorageGroupName + “” + $_.AdminDisplayName + “.bks”
   $JetBackupSyntax | out-file -filepath $BksFileName -encoding unicode
   Add-Content $BksFileName “”
   $BksDescriptiveName = $_.ServerName + “_” + $_.StorageGroupName + “_” + $_.AdminDisplayName
   $NTBackupLine = “C:\WINDOWS\system32\ntbackup.exe backup `”@” + $BksFileName + “`” /n `”” + $BksDescriptiveName + “`” /d `”” + $BksDescriptiveName + “`” /v:no /r:no /rs:no /hc:off /m normal /fu /j `”” + $BksDescriptiveName + “`” /l:s /f `”” + $BackupPath + $BksDescriptiveName + “.bkf`” ”
   Add-Content $BackupScript $NTBackupLine
   }
   & $BackupScript
   }

   perform_backup “ServerName” “R:\”