January 5, 2010 at 1:48 pm
How do you use the Maintenance Plan for a backup to another server. I would like to have all my database backups to not be on the SQL server but on a Backup server.
January 5, 2010 at 2:41 pm
use an execute SQL task to run a backup command pointing to the UNC path of the share on the backup server.
else use the maintenance plan backup task in the normal way and then have a separate process to copy the backups to the backup server. Personally for speed of recovery I like to have the most recent backups on the SQL server.
---------------------------------------------------------------------
January 5, 2010 at 2:47 pm
When box with SQL server dies,your backups will die. In ssms press f1 and in help window look for BACKUP DATABASE statement.
Ideally I would have production server and its backups on 2 SANs and copy of the backup on some old pc or cheap NAS + the good old tapes ofcourse.
January 5, 2010 at 2:59 pm
c00ler01 (1/5/2010)
thats why we have DR processes in place. Separate Issue.
thats another reason not to write all your backups to one server, its a SPOF. A backup of the backup server will be required.
---------------------------------------------------------------------
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply