Backing up databases

Creating backups is the most important task in database administration. Backups allow you to retrieve your data when a server is down, or when configurations, data files, etc. are lost.

Use the DatabaseBackup script to make the following backups:

  • A full backup of SYSTEM_DATABASES databases to be scheduled once a day.

    EXECUTE [dbo].[DatabaseBackup]
    @Databases = 'SYSTEM_DATABASES',
    @Directory = NULL,
    @BackupType = 'FULL',
    @Verify = 'Y',
    @CleanupTime = NULL,
    @CheckSum = 'Y',
    @LogToTable = 'Y'

  • A full backup of USER_DATABASES databases, to be scheduled once a day.

    EXECUTE [dbo].[DatabaseBackup]
    @Databases = 'USER_DATABASES',
    @Directory = NULL,
    @BackupType = 'FULL',
    @Verify = 'Y',
    @CleanupTime = NULL,
    @CheckSum = 'Y',
    @LogToTable = 'Y'

  • A backup of USER_DATABASES database logs, to be scheduled frequently several times per day: every 15 minutes, 30 minutes or hour.

    EXECUTE [dbo].[DatabaseBackup]
    @Databases = 'USER_DATABASES',
    @Directory = NULL,
    @BackupType = 'LOG',
    @Verify = 'Y',
    @CleanupTime = NULL,
    @CheckSum = 'Y',
    @LogToTable = 'Y'