March 2, 2011 at 4:53 am
Hi,
I've got a strange problem at one of my clients sites.
I'm trying to take a differential backup but it can't seem to find the full backup taken previoulsy.
A few weeks ago their internal IT were taking a backup in between us taking our and the differential but hey then moved the backup file off the server, hence the path was broken.
They have stopped doing that backup now but the problem persists.
Details of my investigation are:
The Error:
Cannot perform a differential backup for database "XXX_MSCRM", because a current database backup does not exist. Perform a full database backup by reissuing BACKUP DATABASE, omitting the WITH DIFFERENTIAL option. [SQLSTATE 42000] (Error 3035) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). The step failed.
The Investigation:
SELECT
CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server,
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_start_date,
msdb.dbo.backupset.backup_finish_date,
msdb.dbo.backupset.expiration_date,
CASE msdb..backupset.type
WHEN 'D' THEN 'Database'
WHEN 'I' THEN 'Diff'
WHEN 'L' THEN 'Log'
ELSE msdb..backupset.type
END AS backup_type,
msdb.dbo.backupset.backup_size,
msdb.dbo.backupmediafamily.logical_device_name,
msdb.dbo.backupmediafamily.physical_device_name,
msdb.dbo.backupset.name AS backupset_name,
msdb.dbo.backupset.description
FROM msdb.dbo.backupmediafamily
JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id
WHERE (CONVERT(datetime, msdb.dbo.backupset.backup_start_date, 102) >= GETDATE() - 7)
AND database_name='XXX_MSCRM'
ORDER BY
msdb.dbo.backupset.database_name,
msdb.dbo.backupset.backup_finish_date
The Results:
database_namebackup_start_datebackup_finish_dateexpiration_datebackup_typebackup_sizelogical_device_namephysical_device_namebackupset_namedescription
XXX_MSCRM27/02/2011 01:0027/02/2011 01:15Database8657497088F:\Backup\XXX_MSCRM\XXX_MSCRM_Full_B.bak
XXX_MSCRM27/02/2011 01:1527/02/2011 01:15Diff9760768F:\Backup\XXX_MSCRM\XXX_MSCRM_Diff_B.bak
XXX_MSCRM27/02/2011 03:3027/02/2011 03:31Database7168{0D6484A8-C897-499E-923F-ECB90C230A3C}8
XXX_MSCRM27/02/2011 04:0027/02/2011 04:00Diff7663616F:\Backup\XXX_MSCRM\XXX_MSCRM_Diff_B.bak
XXX_MSCRM28/02/2011 03:3028/02/2011 03:30Database7168{B94CC9EA-33C0-437E-B940-2ED98B76392A}8
XXX_MSCRM28/02/2011 04:0028/02/2011 04:00Diff5566464F:\Backup\XXX_MSCRM\XXX_MSCRM_Diff_B.bak
XXX_MSCRM28/02/2011 19:0128/02/2011 19:02Database7168{106C22BE-E67A-4797-8E42-66CB11C02A21}9
XXX_MSCRM01/03/2011 03:3001/03/2011 03:30Database7168{0709620A-3DF1-4F7E-9BE7-FE2D7E594148}8
XXX_MSCRM01/03/2011 19:0901/03/2011 19:09Database7168{9777F933-0558-41C3-BB14-5D84AE677951}9
My Question:
As you can see, there are many database backups to GUID (which I believe is a virtaul deveice) but the size of them is always 7168.
It is still affecting my Differentails because as you can see between the 27th and 28th the differnetial size decreases, which would surely only happen if there were a full backup between them.
Any guidance is appreciated.
Giles
March 3, 2011 at 7:32 am
Reposted on the SQL Server 2005 backup forum: http://www.sqlservercentral.com/Forums/Topic1072550-357-1.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply