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,551 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,751 reads

Blogs

Enterprise AI Operating Rhythm – Top 5 practices for 2026

By

2025 exposed a growing gap between AI ambition and operational reality. As budgets tightened...

Stop Being Surprised by Your Azure Bill: Use Budgets

By

When organizations migrate workloads to Azure, the focus is usually on architecture, performance, and...

Resetting on the AI hype train

By

There's a great article from MIT Technology Review about resetting on the hype of...

Read the latest Blogs

Forums

Celebrating Tomorrow

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Celebrating Tomorrow

SQL Art: I Made a Christmas Card In SSMS

By tedo

Comments posted to this topic are about the item SQL Art: I Made a...

lookup error

By support@omniverter.com

I am using ssrs in visual studio 2022, I work on a report, there...

Visit the forum

Question of the Day

Celebrating Tomorrow

Which of these is more appropriate for tomorrow?

See possible answers