« SQL Server Recovery Models
SQL Server Differential Backup »

SQL Server Full Backup

A full backup contains all the data in a specific database or set of filegroups or files.

Full Backup

  1. It contains the entire database structure and the related data stored in these structures, to provide recovery.
  2. Without a full backup, differential backups and transaction action log backups are useless.
  3. Full backup is available for database , files and filegroups.
  4. On master database, only full backups are possible.
  5. Under simple recovery model, file and filegroup backups are available only for read-only filegroups.
--Full Database Backup to a single disk device
BACKUP DATABASE [AdventureWorks]
TO DISK = N’C:\backup\AdventureWorks.bak’
WITH INIT, NAME = N’AdventureWorks-Full Database Backup’

Tags:

This entry was posted on Saturday, January 12th, 2008 at 4:05 am and is filed under Backup Database, SQL Server. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply