A database backup is a copy of a database that is created for the purpose of protecting the data in the database from accidental or unauthorized changes. A SQL Server database can be backed up to either a local disk or a network location. A backup can be used to restore the database to its original state, or to restore part of the database.
To create a database backup, you use the BACKUP DATABASE statement. The following is an example …
