Database backup

Perform a full database backup in SQL Server to start database logging in the Full or Bulk-Logged recovery model.

The recovery model will remain ‘simple' until you perform a full database backup. The following example uses a SQL statement to perform a full backup for the ‘pubs' database:

 BACKUP DATABASE pubs TO DISK = 'c:\mssql\backup\pubs.bak'

If you need more information on how to perform this task, see your database administrator or refer to your Microsoft SQL Server documentation.