This documentation is archived and is not being maintained.

File Restore and Database Startup

 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.