How to see backup history through the back-end?

By querying msdb.dbo.backupset and msdb.obackupmediafamily one can see backup history like start and end time, type of backup, location of the backup. select bs.database_name , bs.type , bs.backup_start_date , bs.backup_finish_date , bmf.physical_device_name FROM msdb.dbo.backupset bs , msdb.dbo.backupmediafamily bmf where bmf.media_set_id = bs.media_set_id and backup_start_date > '2010-01-22' testDB D 2010-01-22 00:00:02.000 2010-01-22 05:09:32.000 c:\Backup\testdb_full.bak testDB I…

How to create differential backup?

Using the following T-SQL one can create differential backup or make it part of scheduled job. declare @datetimestamp varchar(20) declare @filename nvarchar(100) declare @name nvarchar(100) SELECT @datetimestamp = REPLACE(REPLACE(REPLACE(CONVERT(VARCHAR(20), GETDATE(), 120), '-', ''), ' ', '_'), ':', '') SELECT @filename = 'C:\testDBBackup\testDBbdiff' + @datetimestamp + '.bak' SELECT @name = 'testDB Diff Backup ' + @datetimestamp…