Tag Archives: SQL Server
See backup chain SQL Server
See the backup chain in SQL Server SELECT TOP 100 s.database_name, CASE s.type WHEN ‘D’ THEN ‘Full’ WHEN ‘I’ THEN ‘Differential’ WHEN ‘L’ THEN ‘Transaction Log’ END AS BackupType, CAST(DATEDIFF(second, s.backup_start_date, s.backup_finish_date) AS VARCHAR(4)) + ‘ ‘ + ‘Seconds’ TimeTaken, s.backup_start_date, CAST(s.first_lsn AS VARCHAR(50)) AS first_lsn, CAST(s.last_lsn AS VARCHAR(50)) AS last_lsn, m.physical_device_name, CAST(CAST(s.backup_size / 1000000 [...]
SQL: maintenance plan delete after server rename
In a previous post I spoke about changing your database server name. If you created a maintenance plan, you might notice that the plan will fail. This is because the connection of your maintenance plan could be changed. You can delete the maintenance plan by executing the following T-SQL (just change the Maintenance plan name: [...]
Login