Use this logic to get the Mirrored Status across all databases. use master; set nocount on declare @get_database_mirroring_state varchar(max) set @get_database_mirroring_state = ” select @get_database_mirroring_state = @get_database_mirroring_state + ‘declare @monitorresults_’ + cast(database_id […]
Here’s some quick sql logic to show you the state of your Mirrored database.
Here’s some very basic sql logic that shows when a database was last accessed.
Here’s some SQL logic that will basically give you the data, log, and total (data + log) in GB. Additionally; all sizes are rounded (ceiling). SQL logic for totals for reference Note: […]
Here’s some SQL logic that checks for the Trigger [trig_check_for_job_failure]. If it does not exist it will automatically create it. Again; what this trigger does is simply executes the Job: Send SQL […]