backup to two different locations

Is it possible to backup a database to two seperate
locations? Not filegroups or striping, but have two
complete copies of the backup in two seperate locations
using a single "BACKUP DATABASE" command? Thanks
I do this with an alert that copies the first backup to a secondary
location. To do this create an alert that is triggered when a backup is
taken. The alert the fires off a job the copies the database backup to
another location.
----
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks
|||Not that I am aware of. You could add a job step that copies the file to
the alternate location after the backup step finishes.
Keith
"Rob" <anonymous@.discussions.microsoft.com> wrote in message
news:2319f01c45e05$e79f22f0$a501280a@.phx.gbl...
> Is it possible to backup a database to two seperate
> locations? Not filegroups or striping, but have two
> complete copies of the backup in two seperate locations
> using a single "BACKUP DATABASE" command? Thanks