January 22, 2010 at 1:48 am
Hi,
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 an urgent.I appreciate your kind help.
Thank you,
Chowdary.
January 22, 2010 at 1:51 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:15 am
Please don't cross post.
Duplicate post:
http://www.sqlservercentral.com/Forums/Topic851802-146-1.aspx
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply