limit the size of DB backup

• abishekshroff

  SSCrazy

  Points: 2040

  More actions

  April 8, 2009 at 9:09 pm

  #202674

  Like in oracle were if i can limit the piece size say 5GB.

  so if my backup is of 10GB, then it will create 2 files of 5GB.

  Is there any way to do in SQL .

• Eswin

  SSCrazy Eights

  Points: 8320

  More actions

  April 8, 2009 at 11:37 pm

  #974840

  BACKUP DATABASE [Database_Name] TO

  DISK = N'D:\Backup_folder\Database_Name_1.bak',

  DISK = N'C:\Backup_folder\Database_Name_2.bak'

  This will divide and save your backup.

  Tanx 😀

• abishekshroff

  SSCrazy

  Points: 2040

  More actions

  April 9, 2009 at 4:33 pm

  #975492

  This dont gurantee 5GB. I tried and one was 5.4 and other was around 4.6 % . Its approximately same but it is not the exact figure