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.
| Author |
Topic |
|
supersql
Yak Posting Veteran
99 Posts |
 Posted - 2007-05-01 : 14:13:48
|
| Finally I have decided to do log shipping thorugh FTP because that is the only way we have. We are just connected with public internet, and thats all we have. so here is the process....1)Initially am going to take a full back up(one time process) from all the different places through Remote Desktop and apply them in my server.2) Setup all the servers to do Trans Backup for every 12hrs by tht way we'll have just 2 files3) These 2 files will be uploaded to ftp site every day which will be automated4) Same 2 files will downloaded through ftp into my server and then apply them to the databases.I want to automate this complete setup and have some notifications if any failure. I myself have to work on the source servers through Remote Desktop.Please let me know the possibilities and Issues that can cause with this kind of setup |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-01 : 14:21:30
|
| You will not be able to use log shipping with this setup. You will need to write custom log shipping code to do this. It shouldn't be a big deal though. You can probably use Nigel's custom code to do it. Check out his site. His userid is nr here.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
supersql
Yak Posting Veteran
99 Posts |
Posted - 2007-05-01 : 14:52:36
|
| Sorry I Cudnt find that article there. I just want to know at the point of failure, do I need full DB backup restore to get updated or can just work with all TRANS backups from the point of failure. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-01 : 15:06:48
|
| It depends. Typically you will only need the transaction logs that haven't been applied yet.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Log Shipping