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? ThanksI 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|||Not in SQL Server 2000, but most likely available in SQL Server 2005
(http://www.microsoft.com/sql/yukon/productinfo/top30features.asp).
<plug> MiniSQLBackup has this feature now, allowing you to make 2 or more
copies of the same backup file using a single BACKUP DATABASE command. All
backup files are created concurrently, not copied off the first backup file.
Download the trial and give it a spin.</plug>
Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup
"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