September 17, 2009 at 9:46 am
Hi,
Can anyone help me out how to take a backup of a database between a specified duration.
For ex, i want to take back up between August 1st 2009 and September 1st 2009.
Regards
Jim
September 17, 2009 at 10:12 am
1) Create your backup script or maint Plan
2) Create a scheduled job eg, every day at 1 am
3) Under "Duration" set the Start Date and End Date
September 18, 2009 at 7:43 am
Jim-1146873 (9/17/2009)
Hi,Can anyone help me out how to take a backup of a database between a specified duration.
For ex, i want to take back up between August 1st 2009 and September 1st 2009.
Regards
Jim
Do you mean that you only want to backup data that changed over the month and no other data?
You can't. You can't backup sub-sets of the data. You can backup sub-sets of the database, file, filegroup, etc., but that's not the same thing.
To do something like this you would need to create an SSIS (or some other ETL) process to pull the data based on dates.
Another option, one that I'm not too up on the details, would be to partition your system, creating a seperate partition by date, for every table, and then you can backup just that partition.
"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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply