Gasire locatii backup-uri pe un server MSSQL

Configurare noua (How To)

Situatie

Mai jos este un script care, rulat pe un server MSSQL, returneaza locatia sau locatiile in care au fost efectuate salvarile.

Solutie

SELECT
TOP 100
backupset.database_name,
backupset.type,
backupset.name,
backupmediafamily.physical_device_name,
backupset.backup_finish_date,
backupmediafamily.logical_device_name,
backupmediafamily.device_type

FROM backupset
JOIN backupmediafamilyON backupset.media_set_id = backupmediafamily.media_set_id

WHERE backupset.type = ‘D’
ORDER BY
backupset.backup_finish_date DESC,
backupset.database_name DESC

Tip solutie

Permanent
Etichetare:

Voteaza

Up Down
(8 din 13 persoane apreciaza acest articol)
Share
Tweet
Share

Despre Autor

Leave A Comment?