Scripts

Technical Article

Faster Log Shipping Restores

When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.

5 (1)

You rated this post out of 5. Change rating

2015-12-11 (first published: )

2,832 reads

Technical Article

Database Backup Information Scripts

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

4.67 (3)

You rated this post out of 5. Change rating

2015-11-25 (first published: )

1,728 reads

Blogs

The pros and cons of self-service BI: What every industry leader should know

By

The post The pros and cons of self-service BI: What every industry leader should...

Off to the PASS Data Community Summit 2024

By

As this publishes, I’ll get taxiing down the runway at DIA (fingers crossed) and...

Implement a RAG Solution Using Azure SQL Database

By

AI and ChatGPT are all the rage these days.  Seems like around every corner...

Read the latest Blogs

Forums

Database deployment on-prem vs data center

By Casper101

We currently have a number of applications connecting to a SQL Server 2022 database....

SQL 2022 - CPU High Utilization

By haichells

Dear All, We have been facing this issue from last 3 months and unable...

Cloud Sources for the Data Migration Assistant

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Cloud Sources for the Data...

Visit the forum

Question of the Day

Cloud Sources for the Data Migration Assistant

Which cloud sources can be used for the current Data Migration Assistant (Sep 2024)

See possible answers