Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
new differential or log backup features best practices help Options · View
Previous Topic · Next Topic
Guest
#1 Posted : Friday, January 08, 2010 12:25:06 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 610
Hello,

I am looking for some examples on the new differential backup setup... What I am looking for is the following:

I have multiple stores and I use this to do backups of the db's anc copy to usb sticks and then ftp to remote server. Well the db's are 2+ gigs. I am looking to utilize the new feature to spread-out the full backup of each remote db and then throughout the week to a diff or log (whichever is better) so that I don't do full 2+ gig backup everyday... Can someone recommenced a best practices of how to do this using this product please?

Also I would like to know if I could do a diff or log throughout the day so that if the drive fails a can restore the daily full from the night before and then a diff or log (depending on the best solution) from the last hour diff or log's to recover???

Thanks,

Mike
Back to top
  |
alex
#2 Posted : Monday, January 11, 2010 3:13:55 AM Quote
Rank: Administration

Groups: Registered

Joined: 8/10/2009
Posts: 143
Hello Mike,

Guest wrote:
Hello,

I am looking for some examples on the new differential backup setup... What I am looking for is the following:

I have multiple stores and I use this to do backups of the db's anc copy to usb sticks and then ftp to remote server. Well the db's are 2+ gigs. I am looking to utilize the new feature to spread-out the full backup of each remote db and then throughout the week to a diff or log (whichever is better) so that I don't do full 2+ gig backup everyday... Can someone recommenced a best practices of how to do this using this product please?


You can read how to set differential and transaction log backups here

Guest wrote:

Also I would like to know if I could do a diff or log throughout the day so that if the drive fails a can restore the daily full from the night before and then a diff or log (depending on the best solution) from the last hour diff or log's to recover???

Thanks,
Mike

Yes, you can do that. Also, please read this article to select appropriate strategy.
Back to top
WWW  Report Abusive | Report SPAM
Guest
#3 Posted : Tuesday, January 12, 2010 11:13:24 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 610
Thanks Alex... I did not find that article earlier....
Back to top
  |
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.