• Dear Gilamonster and cranfield

    Thank you for replies.Rightnow we were using a tool for backing up the database

    mbactrack from BMC. Backup of a 43GB(95% full) occupies 9 Gb on local disk !

    Unfortunately it was decided to move on to MSSQL backups and we tested on

    a development dtabase a db of 40Gb with 38GB data takes 37GB on disk !!

    Regarding the network issue.We faced issues with network when doing tape backup

    from local disk .Issue with tape backup is that when it is trying to takethe bkp of

    this big chunk at times is getting disconnected ,reasons not yet know to us.

    So I thought if it is possible to take bkp on three to four files of 10Gb each it could

    help even when tapebkp fails ! We need not have to start the tape backupall over again .

    Instead we can identify the files not backed up and start the tape bkp again.

    Thank you for helping

    Best Regards,

    Rajeev