Syntex for restore filelistonly & restore verifyonly

Question

Hello,

Would some one please help me with the syntex on how to run "restore filelistonly" or restore verifyonly" on a SQL backup which has multiple filesets?? My backups locations are as follow:

RESTORE VERIFYONLY

From disk = 'E:\syndicated_databank__bkup_01.bak',

                      'E:\syndicated_databank__bkup_02.bak',

                       ‘E:\syndicated_databank__bkup_03.bak’,

                        ‘E:\syndicated_databank__bkup_04.bak’,                        ‘E:\syndicated_databank__bkup_05.bak’

I tried to do a restore with the above, I got error The label 'E' has already been declared. Label names must be unique within a query batch or stored procedure.

Please advise!!

Answer 1

RESTORE VERIFYONLY

FROM DISK = 'C:\VerifyBackups\AW_3.bak',

DISK = 'C:\VerifyBackups\AW_4.bak'

Answer 2

Thank you Derek.

It is working.