File Restore and Database Startup

Icon showing a blue database disk This topic is relevant only for SQL Server databases that have multiple filegroups.

When a database is started, only filegroups whose files were online when the database was closed are recovered and brought online.

If a problem is encountered during database startup, recovery fails, and the database is marked as SUSPECT. If the problem can be isolated to a file or files, the database administrator can take the files offline and try to restart the database. To take a file offline, you can use the following ALTER DATABASE statement:

ALTER DATABASE database_name MODIFY FILE (NAME = 'filename', OFFLINE)

If startup succeeds, any filegroup that contains an offline file remains offline.

Community Additions