Take the 2-minute tour ×
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. It's 100% free, no registration required.

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
    
Programming related? –  Filburt Jun 30 '11 at 8:22
add comment

migrated from stackoverflow.com Jun 30 '11 at 10:55

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

4 Answers

You can split the backup into multiple files

Check http://www.mssqltips.com/tip.asp?tip=935

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
1  
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
add comment
up vote 2 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
add comment

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
add comment

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
1  
I need without increasing size of D,E,F. –  sriakanth Jun 30 '11 at 7:27
add comment

Your Answer

 
discard

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