take last databackup(data only)in small size

[vpn2012]

I have 4 branches and i want to take last backup of data(data only) from 4 branches then but in main branches(all databases have same structure and tables every thing) what are the solutions to solve the problem
i have software SOL server 2005

 

[simian336]

Not sure if I understand what you are trying to do. You may want to provide a data sample and the desired result.

Smi