2019-02-19
5,335 reads
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,011 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)
424 reads
2016-11-30
1,196 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,682 reads
It is anoying that someone created a new database and left its recovery mode in simple and it caused your backup jobs to fail.
2015-11-23 (first published: 2015-10-26)
634 reads
2012-07-25
2,693 reads
By Steve Jones
I set goals at the beginning of the year, and I’m tracking my progress...
By Will Assaf
Say you have a temp table and you want to see the columns names. For...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Common Table Expression Misunderstandings
I have a DAG between On prem and Azure. We have a maintenance window...
How can I overcome/fix this? object_name (st.objectid) in the code below returns NULL. (in...