I'm trying to restore a database. I have backups of the PRIMARY and SECONDARY filegroups separately and the logbook. Everything is going well with TSQL.
- Primary fat RESTORE THE DATABASE DatabaseForFileBackups FILEGROUP = & # 39; PRIMARY & # 39; FROM DISK = & # 39; C: - pr.bak & # 39; WITH NORECOVERY - secondary fg RESTORE DATABASE DatabaseForFileBackups FILEGROUP = & # 39; Secondary & # 39; FROM DISK = C: - sc.bak & # 39; WITH NORECOVERY - tail ball with recovery RESTORE DATABASE DatabaseForFileBackups FROM DISK = C: - log.trn & # 39; WITH RECOVERY
But when I try to do with the SSMS GUI, he says
when I select backup of the main server.
How can I restore a database from groups of files with a GUI?
Thank you for your time!