August 25, 2014 at 11:00 pm
i'm working on windows application in c#,there is one requirement like i need to take database backup from one location & restore that to some other location database on specific condition like from date - to date.
Is possible to take only partial data backup from sql server 2008 r2? otherwise please let know other way to do achieve same result?
Note : partial data backup in the sense may be this weeks data i.e. 08/25/2014 to 08/30/2014 whatever data was updated in sql table excluding data before or after this date.
August 25, 2014 at 11:08 pm
No, this is no any way to match your requirement.
August 26, 2014 at 4:30 am
You can't do this through the backup and restore process, no. You'd have to build some type of data migration. That's possible, just a lot of work.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
August 26, 2014 at 7:11 am
Back up and restore is for the entire database. It addresses not only the data changes but also includes table, index et al changes. The destination database will also be similar to the source database. If you interested only in the data changes, then as mentioned by Grant you would need an data migration method.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply