adminbd

Записи по mssql,oracle,windows и linux

Have a Question?

If you have any question you can ask below or enter what you are looking for!

Когда был последний бэкап mssql

SELECT  @@Servername AS ServerName ,
        d.Name AS DBName ,
        b.name,
        b.user_name,
        b.type,
        b.backup_start_date,
        b.Backup_finish_date,
        bmf.Physical_Device_name
FROM    sys.databases d
        INNER JOIN msdb..backupset b ON b.database_name = d.name
                                        AND b.[type] = 'D'
        INNER JOIN msdb.dbo.backupmediafamily bmf ON b.media_set_id = bmf.media_set_id
        where d.name = 'имя базы'
ORDER BY d.NAME ,
        b.Backup_finish_date DESC;

 

Leave a Reply

Your email address will not be published. Required fields are marked *

You can use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>