Backup Striping

• Kishore-132325

  Hall of Fame

  Points: 3784

  More actions

  March 26, 2004 at 12:06 am

  #101936

  Posted - 03/25/2004 :  08:30:10

  Hi, Can we stripe backups so that they can span multiple drives. For instance: Backup of a database on C:\ and D:\. I have created two backup devices..one on C:\ and other on D:\.   How do I backup a database so that it spans both these drives ??

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 26, 2004 at 4:48 am

  #500603

  here this should help

  backup database northwind

  to disk='c:\n1.bak', disk='c:\n2.bak'

  with init, name='test'

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 26, 2004 at 5:25 am

  #500615

  I have read somewhere that the backups devices shoudn't be more than the quantity of processor you have on your server.

  I know that with multiple backup devices, you have multiple threads in paralell. But many backup devices can cause any problem?

   

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 26, 2004 at 6:08 am

  #500622

  Yes that is right. The reason is only one thread at a time can be processed per processor (except with hyperthreaded cpu's) so for each to run the CPU has to divide time between all the threads currently running. The more threads you add the faster the division occurrs and thus the system will start slowing down processing. I have always read thou it was no more than one per processor + 1 but that has been debated and with backups I would suggest 1 per processor for safety.