Introduction
The Database can be backup for avoiding the
lost of data, corrupted data in the sql server. It will generate the .bak file
and it can be restored into the same database later.
Backup
The Back can be taken using the Backup command in
the sql query window. There are two types of medium to back up data. It can
be either Disk or Tape.
BACKUP database TO [Disk/Tape] Path
For example
In the connected sql server there will be
many database. We need to select a database which needs to be backed up the
data.
BACKUP Employees
TO DISK = 'D:EmployeesBackUpFile.bak'
GO
Restore
The backed up database can be restored using
the RESTORE command.
RESTORE database FROM [Disk/Tape] Path
For example
The Employees database the backup data and it can be restored from the path.
RESTORE Employees
FROM DISK = 'D:EmployeesBackUpFile.bak'
GO Screenshots
of Web application