Database

SQLServerCentral Article

Database Snapshot Use Case: Service Migration

  • Article

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.

(1)

You rated this post out of 5. Change rating

2020-08-28 (first published: )

2,566 reads

Technical Article

Database Backup Information Scripts

  • Script

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

(3)

You rated this post out of 5. Change rating

2015-11-25 (first published: )

1,758 reads

Blogs

Overcoming Imposter Syndrome: A Plan

By

My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...

Advice I Like: Celebrate Success

By

“On the way to a grand goal, celebrate the smallest victories as if each...

Programmatically Retrieving MLV Lineage and Refresh Times

By

Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...

Read the latest Blogs

Forums

BCA KCP Kebon Sirih Tlpn/wa:085373737551

By balijepalli.p

Jl. Kebon Sirih No.6A Lantai 1 B, Gambir, Kecamatan Gambir, Kota Jakarta Pusat, Daerah...

Kantor Kas BCA,Telp/Wa 0821.3111.159

By fougito

Supermall Karawaci, Jl. Boulevard Diponegoro No.105 Lantai 1 # A3A, Bencongan, Kecamatan Kelapa Dua,...

BCA KCU ALAM SUTERA,Telp/Wa 0821.3111.159

By fougito

Perumahan Alam Sutera, Jl. Alam Sutera Boulevard No.10A, Pakulonan, Kec. Serpong, Kota Tangerang Selatan,...

Visit the forum

Question of the Day

Increase Deadlock Detection

How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?

See possible answers