RESTORE DATABASE [BAza]
FILEGROUP = N'Primary',
FILEGROUP = N'FG1',
FILEGROUP = N'FG2',
FILEGROUP = N'FG3',
FILEGROUP = N'FG4',
FILEGROUP = N'FG5',
FILEGROUP = N'FG6',
FILEGROUP = N'FG7'
FROM  DISK = N'D:\BAK\BAza_backup_rw.bk' WITH
MOVE N'file1' TO N'G:\BAza\file1.mdf',  
MOVE N'file2' TO N'G:\BAza\file2.mdf',  
MOVE N'file3' TO N'G:\BAza\file3.mdf',  
MOVE N'file4' TO N'G:\BAza\file4.ndf',  
MOVE N'file5' TO N'G:\BAza\file5.ndf',  
MOVE N'file6' TO N'G:\BAza\file6.ndf',  
MOVE N'file7' TO N'G:\BAza\file7.ndf',  
MOVE N'file8' TO N'G:\BAza\file8.ndf',  
MOVE N'Baza_log' TO N'G:\BAza\BAza_log.ldf',  
PARTIAL, NORECOVERY, STATS = 10, REPLACE
GO

..
RESTORE DATABASE ... FILE=<name> successfully.
--------------------
RESTORE DATABASE BAza with recovery
    go
RESTORE DATABASE successfully processed 0 pages in 9.466 seconds (0.000 MB/sec).
--------------------------------------
    SELECT name, state_desc, recovery_model_desc
        FROM sys.databases where database_id = DB_ID('BAza')
    go

        name    state_desc      recovery_model_desc
        -------------------------------------------
        BAza     ONLINE            FULL
--------------------------------------------

select file_id, is_read_only, state_desc from sys.database_files
    go

file_id is_read_only state_desc
1         0               ONLINE
2         0               ONLINE
3         0               ONLINE
4         0               ONLINE
5         0               ONLINE
6         0               ONLINE
7         0               ONLINE
8         0               ONLINE
9         1               RECOVERY_PENDING
10       1               RECOVERY_PENDING
11       1               RECOVERY_PENDING
__________________________________

filegroupurile create la partitionarea tabelului amintit mai sus au ramas pe disc.
In ele ar trebui sa existe date identice cu datele aceluiasi tabel din grupul  Primary (tabelul din baza restabilita nu este partitionat!)
Nu prea inteleg cum lucreaza Serverul SQL