Browse by Tags

• 2008
• bulk
• compression
• katmai
• Powershell
• read-only
• tsql

• Restore-SqlDb - Automate a Database Restore (improved with Powershell)

  UPDATE: This script requires the Invoke-TryCatch.ps1 and the newly posted Invoke-Nz.ps1 scripts as well - thanks to all who pinged me about the Inovke-Nz.ps1 being required. A while back I posted on Automating a Database Restore and it was quite a popular... Posted Oct 12 2008, 09:01 PM by Chad Boyd with | with 3 comment(s) Filed under: backup, Powershell

• Automate a Database Restore

  NOTE: See an updated version of this functionality using Powershell and supporting some additional functionality here . It's quite common to see automated/custom procedures for backing up a database/log - nearly everywhere I go companies have custom... Posted Jul 29 2008, 06:19 PM by Chad Boyd with | with 4 comment(s) Filed under: backup, tsql

• Katmai (Sql 2008) - Data Compression (including Backup Compression)

  This post will cover an initial overview of the data compression feature that will be included in Sql Server 2008, and I'll also cover briefly some information on the Backup Compression feature as well (note that these are 2 totally separate and distinct... Posted Oct 15 2007, 11:31 PM by Chad Boyd with | with 5 comment(s) Filed under: backup, 2008, katmai, compression

• Large log backups with bulk operations and read-only databases

  So, here's an interesting scenario I ran into a few weeks back. A customer had a situation in which they were using a read-only database (to serve reports/ad-hoc queries during production hours) that was loaded nightly with differential data from... Posted Oct 15 2007, 11:29 PM by Chad Boyd with | with no comments Filed under: read-only, bulk, backup