Welcome to MSSQL Forum!
MSSQL Forum - Discussions about Microsoft SQL Server

You are currently viewing our community forums as a guest user. Sign up or
Having an account grants you additional privileges, such as creating and participating in discussions.

Is it necessary to restore 2ndry filegroup ?

Discussion in 'Installation and Administration' started by dbsps, Dec 15, 2017.

  1. dbsps

    dbsps New Member

    Hi,
    I have 2 Filegroups i.e. Primary & Secondary in my database, Secondary filegroup is dedicated to non-clustered indexes.

    Now I want to restore only Primary filegroup on non-production environment without Secondary filegroup - does that database runs fine with application ? As the indexes file is too big to restore.
    What if on insert - non-clustered index is fired which is on 2ndry filegroup which is not there to serve ?
    Do i have to remove all indexes that fall in 2ndry filegroup on all base tables that reside on Primary filegroup ?

    Suggestion pl.

Share This Page