Unanswered: Backup over 50 databases to another location
I need to back up about 50 databases that are currently sitting on MARS. Every saturday they will be backuped so that they can be moved to HOMER
Pls help as I don't know where to start
BTW..I have also set up the SQL Maintenance wizared Backup procedure which copies to the local server but I want to be able to move the database files to HOMER (another server) so eventually they are backed up by TAPE
If you have used the wizard to set up a backup process, then all you need to do is copy the backup files to HOMER and restore them there. If this is done frequently then you can set up a SQL script to restore them.
If it's not practically useful, then it's practically useless.