Home Forums SQL Server 7,2000 Backups Split backup across several drives ?? RE: Split backup across several drives ??

  • May 25, 2004 at 6:08 pm

    #507778

    Just use 2 destinations in your BACKUP command.  eg.

    BACKUP DATABASE mydb TO DISK = 'G:\mssql\backup\mydb1.bak, DISK = 'H:\mssql\backup\mydb2.bak' with init


    Cheers,
    - Mark