Tag Archives: Backup/Recovery

Restoring a Striped Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I uncompressed some SQL Backup Pro files. Since multiple threads were used to make the backup, I ended … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

The Writeable Warm Standby

I saw a question recently that went like this: I get one full backup from FTP. I’ll get daily log backups through FTP after this, but never another full. I need to restore this daily log backup and allow the … Continue reading

Posted in Blog | Tagged , , , | Comments Off on The Writeable Warm Standby

The Log Chain

I ran across a question recently from someone that received a similar message to the one showed in this image: In this case, the log chain is broken. I’ve received this message, usually from a script that is automatically restoring … Continue reading

Posted in Blog | Tagged , , , | Comments Off on The Log Chain

Attaching All Databases with PowerShell–Refactoring out Write-Host

Someone posted a note to me on Twitter that noted that Write-Host is not recommended for your scripts. I checked the link to an MSDN blog on Write-Host Considered Harmful, and it made some sense. Basically it says that since … Continue reading

Posted in Blog | Tagged , , , , | Comments Off on Attaching All Databases with PowerShell–Refactoring out Write-Host