Split backup across several drives ??

• kknudson

  SSCarpal Tunnel

  Points: 4986

  More actions

  May 25, 2004 at 10:15 am

  #111247

  I have a DB on a server, the DB is roughly 50gig, being a good DBA I split it across several drives.  But along with all of the other DBs on the box I have 2 drives with 32 gig ea free.  It might (might) fit in either, particularly with NTFS compression, I know it's not recommended, but I use it all the time without problems.

  But, I would like to spread it across the 2 drives with free space.  Without getting into filespace backups, plan B.  Any way to tell the backup program to put it on both drives ??

  
  KlK

• mccork

  SSC-Insane

  Points: 22288

  More actions

  May 25, 2004 at 6:08 pm

  #507778

  Just use 2 destinations in your BACKUP command.  eg.

  BACKUP DATABASE mydb TO DISK = 'G:\mssql\backup\mydb1.bak, DISK = 'H:\mssql\backup\mydb2.bak' with init

  
  Cheers,
  - Mark

• Gabriela Nanau

  SSCommitted

  Points: 1967

  More actions

  May 26, 2004 at 9:48 am

  #507875

  Is there any way to control how much will go in the first file and how much in the secound? For a really big database how big will be each of these files? 50%? A different percent according with the size of the data files or to some other factors?

   

   

• mccork

  SSC-Insane

  Points: 22288

  More actions

  May 26, 2004 at 5:09 pm

  #507937

  I *usually* find it's a 50%-ish split.  If you want some control over the % (eg. 40%/60%) you may have to backup to 5 files (2 on one device and 3 on the other).

  
  Cheers,
  - Mark