How to restore files and filegroups over existing files (Transact-SQL)

To restore files and filegroups over existing files


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, and replaces any existing files of the same name. 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,

    REPLACE

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 Copying Databases

  


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