Search
 
SCRIPT & CODE EXAMPLE
 

SQL

SQL Database backup history

SELECT
    bs.database_name,
    bs.backup_start_date,
    bs.backup_finish_date,
    bs.server_name, 
    bs.user_name,
    bs.type,
    bm.physical_device_name
FROM msdb.dbo.backupset AS bs
INNER JOIN msdb.dbo.backupmediafamily AS bm on bs.media_set_id = bm.media_set_id
Comment

PREVIOUS NEXT
Code Example
Sql :: sqlite3 turn off case sensitive 
Sql :: sql select lowest value row 
Sql :: average salary in sql 
Sql :: q operator in plsql 
Sql :: mysql set boolean default value 
Sql :: all_dependencies 
Sql :: rename column name sql server 
Sql :: datediff in sql 
Sql :: view table sql 
Sql :: sql rtrim 
Sql :: Query to remove duplicate rows from a table 
Sql :: t_sql contains 
Sql :: sql display max value 
Sql :: PL SQL VARRAY of records 
Sql :: postgresql default value 
Sql :: function in postgresql 
Sql :: get largest number in database sql 
Sql :: multiple replace value mssql 
Sql :: postgresql conectar 
Sql :: psql select * from table 
Sql :: get duplicate entry sql 
Sql :: sql values to array of objects 
Sql :: sql server today minus n 
Sql :: pgadmin see indexes 
Sql :: generate random & unique mysql string 
Sql :: sql search all tables for attributes 
Sql :: group by por mes sql mysql 
Sql :: sql union operator 
Sql :: postegresql update to null 
Sql :: finish transaction sql 
ADD CONTENT
Topic
Content
Source link
Name
4+8 =