RE: [Emerald] Defining Backup devices

Bernard Andrys ( (no email) )
Wed, 5 May 1999 14:23:39 -0400

What about using the Transfer feature of SQL Enterprise Manager? We have a
scheduled transfer from our primary to backup SQL each night. Are there
problems with this that you ran into that made you use a dump/copy/restore
method?

> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of Dale E. Reed Jr.
> Sent: Wednesday, May 05, 1999 2:03 PM
> To: emerald@iea-software.com
> Subject: Re: [Emerald] Defining Backup devices
>
>
> Kelly Wright wrote:
> >
> > How do define a backup device to anyother drive on another
> server? I want
> > our Emerald db to backup everynight to another machines drive.
>
> You can't. SQL Server can only backup to a local drive. What I used
> to do to work around this was I would have two tasks. The first would
> dump the Emerald database on a nightly basis to a dump device, and
> about 1/2 hour later, a second task would copy the file over to
> another machine. I also had a task that ran about 1/2 hour after that
> that would restore the dump on the second machine to an Emerald database
> on it. You could theoretically do this several times a day to
> have a fairly recent backup machine.
>
>
> --
>
> Dale E. Reed Jr. Emerald and RadiusNT
> __________________________________________
> IEA Software, Inc. www.iea-software.com
>