If a web-based GUI is better suited to your admin skills, Jack Wallen wants to show you how to back up and restore your MySQL/MariaDB databases with one of the easiest tools on the market.

PowerShell offers a lightweight and efficient solution for backing up SQL Server Express databases on local workstations without the need for full system backups.

Setting up database replication is one of the most reliable means of getting a real-time backup of your MariaDB data. See how easy this is to achieve.

In part 1, we looked at generating T-SQL style code. In part 2, let's get this thing to run! Last time, I showed how a single SELECT statement can be built to create an executable string of T-SQL.

You've overwritten your "BACKUP DATABASE" command with the "DBCC SHRINKDATABASE" command. Put an "EXEC (@SQL)" in between the two.