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
 General SQL Server Forums
 New to SQL Server Administration
 Incremental backups - how to supply them to client

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 Microbiologist
Winnipeg, 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 those

they'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.
Go to Top of Page

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.

- Lumbago

My blog (yes, I have a blog now! just not that much content yet)
-> www.thefirstsql.com
Go to Top of Page
   

- Advertisement -