backupmediafamily problem

Question

backupmediafamily problem

yogaanand.me

SSCrazy

Points: 2717
More actions
March 29, 2010 at 4:38 am

#142211

hi friends
Recently i changed my BACKUP Place in different server.. and working fine
when i am running
"SELECT * FROM backupmediafamily"
the Physical_device_name is showing old path instead of new path
please help me
Yogi

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ps. One Orange Chip Points: 29422 More actions · Answer 1

yogaanand.me (3/29/2010)
hi friends
Recently i changed my BACKUP Place in different server.. and working fine
when i am running
"SELECT * FROM backupmediafamily"
the Physical_device_name is showing old path instead of new path
please help me
Yogi

did u use the clause <b> order by media_set_id desc </b>?

Pradeep Singh

yogaanand.me SSCrazy Points: 2717 More actions · Answer 2

thanks..

ya i tried ..its like old only

i need "last backup database details"

can please give query to retrieve the data

please help

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 3

yogaanand.me (3/29/2010)
thanks..
ya i tried ..its like old only
i need "last backup database details"
can please give query to retrieve the data
please help
Try this...

SELECT

DATABASE_NAME,[TYPE],BACKUP_FINISH_DATE,

(BACKUP_SIZE/1024/1024) SIZE_MB,PHYSICAL_DEVICE_NAME,

[USER_NAME]

FROM MSDB.DBO.BACKUPSET A JOIN MSDB.DBO.BACKUPMEDIAFAMILY B

ON(A.MEDIA_SET_ID=B.MEDIA_SET_ID) WHERE

--PHYSICAL_DEVICE_NAME like 'e%'and

--DATABASE_NAME in('licm')and

--type ='D'and

BACKUP_FINISH_DATE>=GETDATE()-14 order by BACKUP_FINISH_DATE desc

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/