Redmond Magazine

PowerShell-Based SQL Server Backups Revisited, Part 2

Let's follow up the last column with a step-by-step breakdown shows how the PowerShell script automates SQL Server backups, manages retention, logs activity and verifies data integrity. In my first ...
Network World

So I can’t use BACKUP LOG WITH TRUNCATE ONLY – but what can I do instead?

In an earlier blog entry, I talked about “Deprecated” code and I highlighted the fact that the BACKUP LOG WITH NO_LOG and BACKUP LOG WITH TRUNCATE_ONLY statements are no longer allowed in SQL Server ...
Ars Technica

Find what's creating a SQL backup

I have a SQL server that is freezing IO on all DBs 6 times per day at about 2am, 6am, 10am, 2pm, 6pm, and 10pm. These only freeze IO for approximately 2 seconds each time, but it is long enough that ...
Redmond Magazine

PowerShell Based SQL Server Backups Revisited, Part 1

A couple of months ago, I wrote an article on how to use PowerShell to back up a database within SQL Server Express Edition. Even though the technique that I described in that post works, the script ...