Log shipping over a T1, best pratices

I successfully implemented log shipping but am questioning the xcopy function over a point to point T1. Would it be better to use FTP? The database file is currently 6 gigs in size and takes awhile to copy over. We are doing this with SQL Server 2000 sta
ndard, so we don't get the extra features that Enterprise Edition would give us, whatever they may be. Any suggestions are appreciated.
Thanks,
Denny
ftp is considered to be unsecure. Its performance is much the same as an
xcopy.
"Denny" <anonymous@.discussions.microsoft.com> wrote in message
news:6E15A90F-AB52-4268-B379-B7FE73EA5EED@.microsoft.com...
> I successfully implemented log shipping but am questioning the xcopy
function over a point to point T1. Would it be better to use FTP? The
database file is currently 6 gigs in size and takes awhile to copy over. We
are doing this with SQL Server 2000 standard, so we don't get the extra
features that Enterprise Edition would give us, whatever they may be. Any
suggestions are appreciated.
> Thanks,
> Denny

log shipping - synch

I have to schedule the automatic restore the standby database for
testing backups . The database was already in log shipping mode. Up to
what point do I need to restore the database without affecting the log
shipping sequence? Can we query the log shipping tables for the last
scn applied and recover up to that point? Any suggestoions are welcome.

Thanks

TramHi

Have you checked out other posts regarding re-syncing log shipping. Such as:
http://tinyurl.com/cot3k

If you want to look at manual log shipping check out
http://www.winnetmag.com/Artic*le/A...3231/23231.html
http://tinyurl.com/4ez3l
http://tinyurl.com/6rdth

John

"tram" <tram_e@.hotmail.com> wrote in message
news:1117879701.158308.305390@.o13g2000cwo.googlegr oups.com...
>I have to schedule the automatic restore the standby database for
> testing backups . The database was already in log shipping mode. Up to
> what point do I need to restore the database without affecting the log
> shipping sequence? Can we query the log shipping tables for the last
> scn applied and recover up to that point? Any suggestoions are welcome.
>
> Thanks
> Tram