January 22, 2010 at 1:39 am
We have the database ex: ABC and 187 tables.
In this database we have 12450 Customers Data.If I want to take the backup of ABC database I can take the backup by using the normal backup function.
But one of the Customer asked me to take backup for a perticulat time period.
ex: Customer Name: xyz
Customer_Number: 1000
Backup : from 01-01-2009 to 12-31-2009.
Database : ABC.
If I want to take the backup only for this customer (Including all his data and from all 187 tables), how can I take.Can some please help.Is there any perticular script?
This is urgent.I appreciate your kind help.
Thank you,
Chowdary.
January 22, 2010 at 2:11 am
Replicate with filter to another database. Then backup that database.
January 22, 2010 at 2:23 am
Hello
First you can change the recovery model in to full
Then you take full backup of the database
And then diff backup as per some intervel.
If you need point in restore then use the stopat
Regards
RM Thirunavukkarasu
January 22, 2010 at 2:32 am
write a query to select all the applicable data to this client - export to new table in new database, backup the new database.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 22, 2010 at 2:39 am
The database size is huge.out of 12450 customer I need only one customer data.Database size is 235GB.This customer might be having the data size maximum 15 GB .Instead of taking all 235 GB , can't we take for particular customer data for a particular date range.Please help to write the script for this scenario.
Guys, I appreciate all your replies.
Thank you,
Chowdary
January 22, 2010 at 2:51 am
Please help to write the script for this scenario.
I'm going to do you one better......
Start by doing your own script, post it, and we will assist from there....
No use in us giving you everything (where's the fun in that??) , need to you to think a bit, and then we can help 😀
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 22, 2010 at 2:53 am
ksvchowdary (1/22/2010)
We have the database ex: ABC and 187 tables.In this database we have 12450 Customers Data.If I want to take the backup of ABC database I can take the backup by using the normal backup function.
But one of the Customer asked me to take backup for a perticulat time period.
ex: Customer Name: xyz
Customer_Number: 1000
Backup : from 01-01-2009 to 12-31-2009.
Database : ABC.
If I want to take the backup only for this customer (Including all his data and from all 187 tables), how can I take.Can some please help.Is there any perticular script?
This is urgent.I appreciate your kind help.
Thank you,
Chowdary.
Are the tables in different schema or single schema?
Do you have the date column in all the tables?
January 22, 2010 at 3:02 am
It is a single schema.We do not have date columns in all the datbles.
Thank you,
Chowdary.
January 22, 2010 at 3:11 am
But one of the Customer asked me to take backup for a perticulat time period.
ex: Customer Name: xyz
Customer_Number: 1000
Backup : from 01-01-2009 to 12-31-2009.
If you don't have the date column on all the tables, it may not be possible to filter data for a particular time period.:unsure:
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply