We have two sql servers and I have been running a powershell script on each for the daily full backup.
I was looking at perhaps backing them up using a single script from a 3rd server.
The current scripts backup the databases to another drive on each sql server (for easy access refreshing test systems) then copies them to another server offsite.
The question I have is regarding the backup-sqldatabase command. Is the backupfile parameter referenced from the computer running the script or from the Server running sql? If I specify E:\Backup\file.bak will that be E: on the server running the script or on the SQL Server being backed up?