Category: sqlserverpedia-syndication

Minion Backup: Restore to another server

Post author By Jen McCown
Post date June 28, 2018
Categories In Admin, Minion by MidnightDBA, sql server, sqlserverpedia-syndication, SSC, Tech and Learning
1 Comment on Minion Backup: Restore to another server

Minion Backup makes your SQL Server backups effortless, of course. And even better, it makes your restores effortless! Oh, yes….yes indeed. Today we’ll look at configuring a common, repeatable scenario: take the latest backup of MyDB from ProdServer1 and restore it to DevServer1. There are four basic steps to the setup and execution: Configure Minion Backup and let it […]

The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’

Post author By Jen McCown
Post date June 14, 2018
Categories In Admin, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips, TSQL
1 Comment on The transaction log for database ‘MyDB’ is full due to ‘LOG_BACKUP’

Your transaction log is full. Both Microsoft, and about 100 articles and blogs have covered this topic, but let’s take a quick look anyway. Because, you know, it comes up all the time.

Generate RESTORE LOG statements

Post author By Jen McCown
Post date June 6, 2018
Categories In Admin, Applied SQL, Beginner, Dev, Powershell, sql server, sqlserverpedia-syndication, SSC, Tech and Learning, Tips, TSQL

Today, we’re going to take a specific, simple example of generating RESTORE LOG statements from a directory list of files, using Powershell and find-and-replace.