Let me start by saying I am very new to SQL Server Management.
We are using SQL 2005.
I need to create a Maintenance Plan that will perform backups but save them on another server. We need to keep several months of backups. Everything I have seen online has been to save it to the local server first and write a script to move a specific file name, but I need this to be dynamic because each filename will be unique with a timestamp, right?
If backups should be kept on a different server, why does it look like this is so difficult to do???