yourgre.blogg.se

Back up the AdventureWorks2012 database to new media set. The following example shows how to create a full database backup by using WITH FORMAT to overwrite any existing backups and create a new media set. The following illustration shows the work-loss exposure for a backup strategy that uses only full database backups. Work-loss exposure increases over time between backups. The work-loss exposure increases with each update until the next backup, when the work-loss exposure returns to zero and a new cycle of work-loss exposure starts. Under the simple recovery model, after each backup, the database is exposed to potential work loss if a disaster were to occur. Use a Full Database Backup to Restore the Database For information about how to set TRUSTWORTHY to ON, see ALTER DATABASE SET Options (Transact-SQL).ĭatabase Backups Under the Simple Recovery Modelĭatabase Backups Under the Full Recovery Model TRUSTWORTHY is set to OFF on a database backup.