copy changed data only

i have a databse on a server and i just created an image on the database. now i want to just copy the changed data in all tables withing the database not the whole database eveytime.

Hi,

what about making a differential backups each time ? That will only pull the changes to the full backup each time you backup.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

|||

What I think you are asking is the basis of replication, I would start to look at that and see if it will meet your needs.

|||

Jassim,

As Glenn points out, you're essentially talking about replication. I just wanted to add that SQL Express only supports being a Replication Subscriber, you would need to have a larger Edition of SQL Server (e.g. Standard) to be the Publisher, for replication to work.

Regards,

Mike Wachal
SQL Express team

-
Mark the best posts as Answers!