SQL Server Performance

File & File Group Backup

Discussion in 'SQL Server Log Shipping' started by sourav_tech, Mar 17, 2007.

  1. sourav_tech New Member

    Hello Friends,
    Plz send me the codes to perform the fil group backup.I want to do it using query analyzer only.

    Thanks & Regards,
    Sourav M.
  2. MohammedU New Member

    From BOL...

    BACKUP DATABASE MyNwind
    FILE = 'MyNwind_data_1',
    FILEGROUP = 'new_customers',
    FILE = 'MyNwind_data_2',
    FILEGROUP = 'first_qtr_sales'
    TO MyNwind_1



    MohammedU.
    Moderator
    SQL-Server-Performance.com

Share This Page