Groups | Blog | Home
all groups > sql server replication > may 2004 >

sql server replication : Log shipping over a T1, best pratices


Denny
5/6/2004 12:01:04 PM
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

Hilary Cotter
5/6/2004 10:06:51 PM
ftp is considered to be unsecure. Its performance is much the same as an
xcopy.

[quoted text, click to view]
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.
[quoted text, click to view]

AddThis Social Bookmark Button