Say, we have a database named "Employee" in SQL Server. Now we want to backup the database and then restore the backup database file.
Execute the following SQL to backup Employee to Disk:
Backup Database Employee to Disk='D\DatabaseBack\emp_backup.bak'
After successfully backup, if we want to restore the backup(.bak) file, we have to execute the following SQL:
Restore Database Employee From Disk='D\DatabaseBack\emp_backup.bak'
Differential backups only backup the data pages that have changed since the last full backup. Following is the SQL backup command to perform a differential backup:
BACKUP DATABASE Employee
TO DISK = ‘C:\DatabaseBack\Employee .bak’