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 |
|
rupertsland
Starting Member
9 Posts |
 Posted - 2010-10-14 : 11:19:39
|
| Hi.A client of ours has asked us to supply them with incremental backups of our SQL server database. They want to place a copy on their server. I'm not exactly sure how to do this. The database we are building currently uses the full backup model. I can do backups and provide them on CD, no problem. I would think this is the simplest approach. We are not ready to use differential backups and log shipping, nor can we use database mirroring. Our client understands the database is still under development.If the client wants incremental backups, how do I supply these? Does this involve backing up and providing the differentials and log shipping files?Any suggestions for alternate methods of supplying our client copies of the database?Please note that I am pretty to new to SQL Server (undergoing self-training), and our database contains less than 200 tables.-------------------Dirk Schmid, M.Sc.Environmental MicrobiologistWinnipeg, Canada |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-10-14 : 11:53:56
|
| incremental backups are transaction log backups. since you're using full recovery model, then i assume that you're taking tran log backups.probably they just want proof of progress, in which case its likely you'll have to keep sending them full backup. If they really want transaction log backups, send them thosethey'll need to provide a secure connection (VPN) to their server for you to put any files there. once they do, i'd schedule an automated job to copy the files over. |
 |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-10-15 : 03:14:54
|
| If you get a secure connection (vpn) set up you could create a job in sql server agent that mirrors a local folder on your server with a folder on their server using a nice little program called robocopy.exe which comes with Windows Server 2003 Resource Kit: http://www.microsoft.com/Downloads/details.aspx?FamilyID=9d467a69-57ff-4ae7-96ee-b18c4790cffd. I've used it with great success many timews and it's far better than ftp or whatever in terms of reliability. But if a vpn is not an option then sftp could also be a way to pull it off.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
|
|
|
Incremental backups - how to supply them to client