SQL Server: DB Restore

• Restoring a DB:

RESTORE DATABASE AdventureWorks
FROM AdWorksDevice
WITH RECOVERY

• Restoring Differential Backups in Simple Recovery Mode

RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWFull.bak'
WITH NORECOVERY -- We aren't done with our Restore process

 Then

RESTORE DATABASE AdventureWorks
FROM DISK='D:\SQLBackups\AWDiff.bak'
WITH NORECOVERY

Finally

RESTORE DATABASE AdventureWorks
WITH RECOVERY