May 28, 2004 at 5:10 am
I am doing differential backups: these are the 3 steps used
However, diff backups do not seem to get deleted. ie there are many diff backups on the disk that are prior to the last full backup.
What could the reason for this be, or should I manually delete these diff backups that are prior to the last full backup
1st step dbcc checkdb(SC)
2nd step
BACKUP DATABASE [SC] TO disk = @devicename
WITH INIT
, NOUNLOAD
, DIFFERENTIAL
, NAME = N'SC backup'
, SKIP
, STATS = 10
, FORMAT
, MEDIANAME = N'DOCS - SC Differential Backup'
3rd step
declare @devicename sysname
DECLARE @position INT
SELECT @devicename = physical_device_name
, @position = position
FROM msdb..backupset backupset
INNER JOIN msdb..backupmediafamily backupmediafamily
ON backupset.media_set_id = backupmediafamily.media_set_id
WHERE backup_set_id = (
SELECT MAX(backup_set_id)
FROM msdb..backupset
WHERE database_name='SC'
AND type = 'I'
)
SELECT @devicename physical_device_name
, @position position
May 28, 2004 at 6:36 am
It is a manual process to delete the old differential backups.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply