SQL Server Mirror Backup
Our IT manager at work called me with a question recently about backing up SQL Server to multiple locations via a single backup command. We have Standard edition so it turns out my answer was accurate when I told him I didn’t think it was possible, but I later found out this is a feature in Enterprise edition.
A basic database backup statement to one location looks like this, and we can use this in any edition of SQL Server.