Restore a Database

Hi,

Can someone please tell me what the 'WITH FILE = 1' part of the statement below means please. I am restoring a full and differential backup, I'm just not sure why the differential is 1? Does it just mean that there is 1 file in addition to the Full backup?

Thanks

Code:

---

RESTORE DATABASE MyDB FROM DISK = 'C:\SQLBackups\FullBackup.bak' WITH NORECOVERY
GO
RESTORE DATABASE MyDB FROM DISK = 'C:\SQLBackups\FullBackup.bak' WITH FILE = 1, RECOVERY
GO

---

Follow the next link, it could be helpful

http://msdn.microsoft.com/en-us/library/ms186858.aspx

JG