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
Any ideas
EmerIf 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.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment