Post reply

backup striping failure

  • March 21, 2015 at 10:58 pm

    #398220

    Hi,

    I tried to divide the backup into different files. I am using the same drive but using striping option. The drive has more than 600 GB free space. The database space is around 400 GB. I divided into 5 files. I got the following error

    write failure on backup device 'device name'. Operating system error 112(There is not enough space on the disk.).

    Any suggestions on this

  • March 22, 2015 at 2:41 am

    #1785550

    ramana3327 (3/21/2015)

    Hi,

    I tried to divide the backup into different files. I am using the same drive but using striping option. The drive has more than 600 GB free space. The database space is around 400 GB. I divided into 5 files. I got the following error

    write failure on backup device 'device name'. Operating system error 112(There is not enough space on the disk.).

    Any suggestions on this

    Quick question, can you post your code, looks to me that you are doing 5 times the backup rather than striping it.

    😎

  • March 23, 2015 at 6:28 am

    #1785674

    Hi,

    Ours is Sql Server 2008r2. So used the compression

    I used the below code

    backup database Testdb to

    disk = '\\h:\Backups\Testdb_full__2015032200518_1.bak'

    , disk = '\\h:\Backups\Testdd_full__2015032200518_2.bak'

    , disk = '\\h:\Backups\Testdb_full__2015032200518_3.bak'

    , disk = '\\h:\Backups\Testdb_full__2015032200518_4.bak'

    , disk = '\\h:\Backups\Testdbe_full__2015032200518_5.bak'

    with compression, stats=10

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

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