The backing up and restoring databases and transaction logs is a way that SQL Server provides to protect from data loss. The backup operation creates a copy of a database. This copy can be used to restore the database if the media failure occurs or if the database is somehow damaged (for example, from the user errors).
|
