configuring plans to go to a different drive
- From: childofthe1980s <childofthe1980s@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Apr 2008 10:09:03 -0700
Hello:
In SQL 2005, after creating two separate backup plans (one for each separate
backup drive), is it possible to have SQL automatically backup the databases
to one plan or the other--depending on which one of the two backup drives is
online?
An IT person says that she has two backup drives, F and G. Sometimes F goes
offline and G stays online or vice versa. But, no matter what, one drive is
online while the other goes offline.
I suppose that she could simply create the two separate plans and, depending
on whether one drive or the other is online, SQL will just backup to that
online drive. So, there would be no other special setup or configuration
necessary. Is that correct?
Thanks!
childofthe1980s
.
- Follow-Ups:
- RE: configuring plans to go to a different drive
- From: Linchi Shea
- RE: configuring plans to go to a different drive
- Prev by Date: SQL 2005 install fails with lsass.exe error and reboots
- Next by Date: Re: Cannot install 2005 Developer Edition x64 on new XP x64
- Previous by thread: SQL 2005 install fails with lsass.exe error and reboots
- Next by thread: RE: configuring plans to go to a different drive
- Index(es):