Post reply

Striped Backup

  • August 15, 2008 at 3:04 am

    #191159

    Hi,

    How to perform striped backup via

    a) t-sql

    b) Enterprise Manager

    c) SQL Litespeed

    Thanks in Adv 4 all d help...

  • August 15, 2008 at 3:32 am

    #858580

    Hey,

    Read up about backup Devices.

    From what I understand, you create a device and specify the disks the device belongs to, then you simply do a backup to that device and it will stripe it for you?

    Regards,

    Justin

  • August 15, 2008 at 10:57 pm

    #859079

    I found Query methods for backup and restore..but couldnt get how to do thru' EM and Litespeed.

    backup database MyDB to DISK = N'F:\MSSQLSERVER\BACKUPS\MyDB_DB_01_1.BAK',

    DISK = N'F:\MSSQLSERVER\BACKUPS\MyDB_DB_01_2.bak', DISK = N'F:\MSSQLSERVER\BACKUPS\MyDB_DB_01_3.bak' with init

    same way, we can restore.

    Thanks

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

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