RE: configuring plans to go to a different drive
- From: Linchi Shea <LinchiShea@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2008 20:53:00 -0700
Any rationale why the two drives would take turn to go offline? I'd much
prefer not have to deal with this online/offline business if I'm making
backups. I'm trying to figure out whether a wrong problem is being attempted.
Linchi
"childofthe1980s" wrote:
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
- References:
- configuring plans to go to a different drive
- From: childofthe1980s
- configuring plans to go to a different drive
- Prev by Date: RE: Cross domain authentication in SQL 2005
- Next by Date: upgrate from 2000 to 2005
- Previous by thread: configuring plans to go to a different drive
- Next by thread: Cross domain authentication in SQL 2005
- Index(es):
Relevant Pages
|
