Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

In My Computer, on C drive I have a Database of 50GB and I want to take backup of that 50 GB data to other drives D,E,F but D,E,F Drives contain only 20 GB for each. In this scenario how can i take Backup to other drives of C drive data.

share|improve this question

migrated from Jun 30 '11 at 10:55

This question came from our site for professional and enthusiast programmers.

Programming related? – Filburt Jun 30 '11 at 8:22

You can split the backup into multiple files


share|improve this answer
+1 for being a SQL solution to the question. Plus you get better performance when splitting the backup to multiple devices. – StanleyJohns Jun 30 '11 at 12:45
This should have been as the chosen answer :-). – Marian Jun 30 '11 at 14:24
What matter's is to help others, and exchange idea's isn't it?! Thank you all for the upvoting – niktrs Jun 30 '11 at 15:15
up vote 3 down vote accepted

You could compress the database and split the archiv to 20 GB each (for example with 7zip on commandline).

share|improve this answer
I didn't understand ..Can you elaborate – sriakanth Jun 30 '11 at 7:29
You take for example winzip add the 50GB File to a archiv und split the archiv into 3 parts (two times 20GB one time 10GB) and copy the parts to your drives D,E,F – megaperlz Jun 30 '11 at 7:31

You can't make a backup if there is no space for it. You simply need more space.

You could compress backup after you made it, but you need space to make it. Not sure how much free space you have on C drive. If you have enough, you can backup it to C drive and then compress with whatever zip, rar, 7z whatever you have.

If you had SQL Server 2008 Enterprise, or SQL Server 2008 R2, you could use Backup Compression feature.

Something to consider:

  • there are might be data, that you don't need, so you could delete some
  • try to shrink the datafile

Don't know what OS you have but, you could also create one Spanned Volume from D,E,F.

share|improve this answer

in a very simple way

increse the disk size of D,E,F

Write a house keeping job , to put the data on the tape.

share|improve this answer
I need without increasing size of D,E,F. – sriakanth Jun 30 '11 at 7:27

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.