backup locally and copy file vs backup remotely

Is it more or less the same amount of time to backup a database locally and
then copy the file to another server vs backing up remotely to the
destination ?
ThanksIt is more time to backup locally and copy but I would rather take the extra
time if possible for reliability.
Jason Massie
www: http://statisticsio.com
rss: http://feeds.feedburner.com/statisticsio
"Hassan" <hassan@.test.com> wrote in message
news:egT4dqCRIHA.4880@.TK2MSFTNGP03.phx.gbl...
> Is it more or less the same amount of time to backup a database locally
> and then copy the file to another server vs backing up remotely to the
> destination ?
> Thanks|||If reliability in your backups is a concern you can use the (new in SQL
Server 2005) CHECKSUM option of the BACKUP command and the RESTORE VERIFYONL
Y
command. See BOL for more details.
And of course the only way to prove that your backup is valid is testing a
real restore on some other database server.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"jason" wrote:

> It is more time to backup locally and copy but I would rather take the ext
ra
> time if possible for reliability.
> --
> Jason Massie
> www: http://statisticsio.com
> rss: http://feeds.feedburner.com/statisticsio
> "Hassan" <hassan@.test.com> wrote in message
> news:egT4dqCRIHA.4880@.TK2MSFTNGP03.phx.gbl...
>