• I found that while i restore primary file group in ssms by using only primary file group file backup file i used following script

    RESTORE DATABASE [test] FILE = N'test', FILE = N'test_ndf' FROM DISK = N'D:\test1.bak' WITH FILE = 1, NOUNLOAD, STATS = 10

    GO

    When i created script using ssms i found that i was restoring all file groups using only primary file group backup.But in options page of restore i was not able to remove other file group selections.

    Then from this automated script i changed something as

    RESTORE DATABASE [test] FILE = N'test' FROM DISK = N'D:\test1.bak' WITH Recovery;

    GO

    So here i am restoring only primary file group,the restore was successful but database could not be brought to online message came ,following is the message

    Processed 168 pages for database 'test', file 'test' on file 1.

    Processed 6 pages for database 'test', file 'test_log' on file 1.

    The roll forward start point is now at log sequence number (LSN) 37000000024300001. Additional roll forward past LSN 37000000028900001 is required to complete the restore sequence.

    This RESTORE statement successfully performed some actions, but the database could not be brought online because one or more RESTORE steps are needed. Previous messages indicate reasons why recovery cannot occur at this point.

    RESTORE DATABASE ... FILE=<name> successfully processed 174 pages in 0.283 seconds (4.786 MB/sec).

    So how can i restore only primary file group? And why above message has come?