Mirroring database useing FTP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Replication (2005)

Mirroring database useing FTP

Author

Topic

davidhills
Starting Member

14 Posts

Posted - 2009-01-23 : 04:15:33

Good Morning

I would like to Mirror my sequal server 2005
where the conection between the two servers is only a ftp link.

Is such a configuration possible, and if yes is there a titorial some where, about how to set it up?

I am just after a passive, as upto date copy as possible.

Maybe mirroring is not the best solution in this case?

The database is large and my FTP link is limited to 2meg

but there is relativly little transactions going on.

thanks

David Hills

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-01-23 : 05:04:27

You're probably looking for log shipping then...don't think mirroring would be possible over port 21/22. And there are quite a few resources available:

http://www.google.no/search?hl=no&q=sql+log+shipping&btnG=Google-s%C3%B8k&meta=&aq=f&oq=

- Lumbago

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-23 : 09:34:30

You can configure Tran Replication in FTP as well.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources