Backup And Restore Database in SQL SERVER

Backup and Restore in SQL Server


Backup Database Employee to Disk='D\DatabaseBack\pubs.bak'

Restore Database Employee From Disk='D\DatabaseBack\pubs.bak'

Differential Backup:

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'
WITH DIFFERENTIAL


Full Backup:

Backup Database Employee to Disk='D\DatabaseBack\pubs.bak'

Init Backup:


BACKUP DATABASE Employee
TO DISK = 'C:\DatabaseBack\Employee .bak'
WITH INIT

Backup in Log:

Backup Log Employee
to Disk = 'C:\DatabaseBack\Employee_log .bak
'