Sql Help Urgent

[Suhaas]

nee query work ayyindi baa.. got the expected results... thanq so much baa 

 

  S%Hi

[Bairagi From Bapatla]

#4H#  S%Hi

  S%Hi

 

[k2s]

[pandugadu999]

naku oke okka record vachindi bhayya... 
for example db01 - bkp date 04/02

db02 - 04/01

db02 - 03/31

db03 - 04/01

 

result lo db01, db02,db03 3 records ravali but nee query ki db01 okkate vasthundi

 

mari nuvvu nee question lo, group by database name kavali ani adgali appudu.......adi cheppale. so neeku each database ki max(startdate), max(finishdate) ravali kada,,,,,correcte na?

 

 

okay idhi try chey,,
 

 

 

 

 

WITH  xyz as (

SELECT
s.database_name,
m.physical_device_name,
CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,
s.backup_start_date,
s.backup_finish_date,
CASE s.[type]
WHEN 'D' THEN 'Full'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Transaction Log'
END AS BackupType,
s.server_name,
s.recovery_model
FROM msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id
where type = 'D' and server_name = 'server' )


select * from xyz where backup_start_date in (select max(backup_start_date) from xyz

                                                                          group by database_name )

union

select * from xyz where backup_finish_date in  (select max(backup_finish_date) from xyz

                                                                               group by database_name)

 
ORDER BY database_name,backup_start_date DESC, backup_finish_date
GO

[Bairagi From Bapatla]

mari nuvvu nee question lo, group by database name kavali ani adgali appudu.......adi cheppale. so neeku each database ki max(startdate), max(finishdate) ravali kada,,,,,correcte na?

 

 

okay idhi try chey,,
 

 

 

 

 

WITH  xyz as (

SELECT
s.database_name,
m.physical_device_name,
CAST(CAST(s.backup_size / 1000000 AS INT) AS VARCHAR(14)) + ' ' + 'MB' AS bkSize,
s.backup_start_date,
s.backup_finish_date,
CASE s.[type]
WHEN 'D' THEN 'Full'
WHEN 'I' THEN 'Differential'
WHEN 'L' THEN 'Transaction Log'
END AS BackupType,
s.server_name,
s.recovery_model
FROM msdb.dbo.backupset s
INNER JOIN msdb.dbo.backupmediafamily m ON s.media_set_id = m.media_set_id
where type = 'D' and server_name = 'server' )


select * from xyz where backup_start_date in (select max(backup_start_date) from xyz

                                                                          group by database_name )

union

select * from xyz where backup_finish_date in  (select max(backup_finish_date) from xyz

                                                                               group by database_name)

 
ORDER BY database_name,backup_start_date DESC, backup_finish_date
GO

Gussa kaku maama... idhi work ayyindi thnQ so much

[Bairagi From Bapatla]

emaindi baa