• Search for:

    1. Home
    3 Oct, 2022
    Sybase Replication: How to check table level replication 0 (0)
    Sybase Replication , , ,

    Below query needs to be run on RSSD database to check Sybase table level replication details.

    select SUBSTRING(db1.dsname,1,20) as SRC_SRV,
    SUBSTRING(db1.dbname,1,20) as SRC_DB,
    '—' as direction,
    SUBSTRING(db2.dsname,1,20) as TGT_SRV,
    SUBSTRING(db2.dbname,1,20) as TGT_DB,
    SUBSTRING(ro.phys_tablename,1,40) as 'SRC_Table',
    SUBSTRING(ro.deliver_as_name,1,40) as 'TGT_Table'
    from     … Read the rest

    27 Sep, 2022
    T-SQL query to check last Full, Differential and Log Backup Times 0 (0)
    MSSQL, T-SQL Scripts , , , ,

    Below query can be used to check last full, differential and transaction log backup times in SQL Server.

    SELECT sd.[Name] AS DatabaseName,
    LastFullBackUpTime=(SELECT MAX(bs.backup_finish_date) FROM msdb.dbo.backupset bs WHERE
    bs.[database_name]=sd.[name] AND bs.[type]='D'),
    LastDiffBackUpTime=(SELECT MAX(bs.backup_finish_date) FROM msdb.dbo.backupset bs WHERE
    bs.[database_name]=sd.[name] AND bs.[type]='I'),
    … Read the rest