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