Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

backup for a perticular Customer Expand / Collapse
Author
Message
Posted Friday, January 22, 2010 1:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, February 14, 2012 2:37 AM
Points: 4, Visits: 12
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.

Post #851809
Posted Friday, January 22, 2010 1:51 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 28, 2014 5:47 AM
Points: 1,904, Visits: 2,827
write a query to select all the applicable data to this client - export to new table in new database, backup the new database.


----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #851812
Posted Friday, January 22, 2010 2:15 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 4:17 AM
Points: 1,101, Visits: 5,279
Please don't cross post.

Duplicate post:
http://www.sqlservercentral.com/Forums/Topic851802-146-1.aspx
Post #851834
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse