SELECT name AS [Database Name],CONVERT(varchar(10),create_date,111) as [Create Date],
recovery_model_desc AS [Recovery Model]
FROM sys.databases
order by [Create Date] desc,[Recovery Model] desc
GO
-- Run following to set a database's recovery mode to "Full":
Use Master;
go
ALTER DATABASE [put database name here] SET RECOVERY FULL
GO
SELECT name AS [Database Name],CONVERT(varchar(10),create_date,111) as [Create Date], recovery_model_desc AS [Recovery Model] FROM sys.databases order by [Create Date] desc,[Recovery Model] desc GO note: list all database recovery mode and created date with newest one listing on top. You can see if a database that has recovery mode as simple caused your transaction log backup to fail. Run following to set a database's recovery mode to "Full": Use Master; go ALTER DATABASE [put database name here] SET RECOVERY FULL GO
2019-02-19
5,335 reads
In this article, we show how we used Database Snapshots as a rollbackup plan for a database migration from one data centre to another. Database Snapshots proved to be the best route since we sould not afford the time a backup/restore approach would take.
2020-08-28 (first published: 2018-12-11)
2,514 reads
A script to be used as part of development deployments where new databases are required, so as to provide standardisation.
2017-01-23 (first published: 2017-01-18)
448 reads
2016-11-30
1,207 reads
Scripts used to validate the backups information as below
1) Database Backups for all databases For Previous Week
2) Most Recent Database Backup for Each Database
3) Most Recent Database Backup for Each Database - Detailed
4) Databases Missing a Back-Up Within Past 24 Hours
2015-11-25 (first published: 2015-11-03)
1,728 reads
