log messages

Hi,

We are using SQL Server 2012. From last few days I see different messages in db log file.

Before I have below log messages.

Now I have below additional messages in logfile as below.

We have full backup configured, no differential backups.

Please suggest


February 2nd, 2015 2:30am

You may execute the below query and see:

SELECT  
   CONVERT(CHAR(100), SERVERPROPERTY('Servername')) AS Server, 
   msdb.dbo.backupset.database_name,msdb.dbo.backupset.server_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 'Differential' 
       WHEN 'L' THEN 'Log'  
   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 ,user_name
FROM   msdb.dbo.backupmediafamily  
   INNER 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() - 10)  
ORDER BY  
    msdb.dbo.backupset.backup_finish_date desc

Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2015 2:35am

Bilal

Take a look at msdb  database to check for backup strategy. Make sure the maintenance plan does not perform a differential backup of msdb database,

February 2nd, 2015 2:42am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics