Post reply

limit the size of DB backup

  • 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 .

  • 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 😀

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply