How to restore files and filegroups (Transact-SQL)

To restore files and filegroups


Important The system administrator restoring the files and filegroups must be the only person currently using the database to be restored.


  1. Execute the RESTORE DATABASE statement to restore the file and filegroup backup, specifying:
  2. If the files have been modified after the file backup was created, execute the RESTORE LOG statement to apply the transaction log backup, specifying:
Examples

This example restores the files and filegroups for the MyNwind database. Two transaction logs will also be applied, to restore the database to the current time.

USE master

GO

-- Restore the files and filesgroups for MyNwind.

RESTORE DATABASE MyNwind

    FILE = 'MyNwind_data_1',

    FILEGROUP = 'new_customers',
    FILE = 'MyNwind_data_2',

    FILEGROUP = 'first_qtr_sales'

    FROM MyNwind_1

    WITH NORECOVERY

GO

-- Apply the first transaction log backup.

RESTORE LOG MyNwind
    FROM MyNwind_log1

    WITH NORECOVERY

GO

-- Apply the last transaction log backup.

RESTORE LOG MyNwind
    FROM MyNwind_log2

    WITH RECOVERY

GO

See Also
RESTORE Restoring File or Filegroup Backups

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.