I am using script to take mysql database backup... its arrround 12 GB ...... I have used tar -a , cp -a and rsync -a to take backup on CIFS mounted drive but it fails to take backup more than 2 GB as well as not able to take backup with ownership,timestamps.
What's the filesystem type behind the CIFS mount? Some Windows file systems simply cannot store more than 2GB in a single file.
You might be able to chunk the backup into multiple files using the split command; I have done so on a number of occasions. Just make sure you give a long enough zero-padded numeric suffix to split so it doesn't get too pesky to reconstruct in which order the files should be glued back together.