File & File Group Backup | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

File & File Group Backup

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.
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
]]>