June 2025 Discount: Comprehensive Database Performance Health Check | Testimonials

Home
  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check
Restoring State

SQL SERVER – Source Database in Restoring State

October 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Scripts, SQL Server, SQL Server Management Studio, SSMS

A client whom I often help with Health Check recently reached out to me with an interesting problem about Source Database in Restoring State.

Read More
Restore Date

SQL SERVER – Get Last Restore Date

September 10, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Scripts, SQL Server

Let us learn how to get the last restore date for the backup in SQL Server. Here is a very simple script for the same. Let me know your feedback.

Read More
copy database

Copy Database – SQL in Sixty Seconds #169

May 27, 2021
Pinal Dave
SQL Video
SQL Backup, SQL in Sixty Seconds, SQL Restore

At that time I use this technique of copy database while keeping the database online. This method is very simple and efficient.

Read More
backup files

Multiple Backup Copies Stripped – SQL in Sixty Seconds #156

February 19, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL in Sixty Seconds, SQL Restore, SQL Server, SQL Server Management Studio, SSMS

Yesterday I blogged about SQL SERVER – Creating Multiple Backup Copies. I got an amazing response to the blog post. Let us learn it today.

Read More
backup files

SQL SERVER – Creating Multiple Backup Files – Stripped

February 18, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Server, SQL Server Management Studio, SSMS

One of my long-term clients (Comprehensive Database Performance Health Check) recently asked me question if I know a way of creating multiple backup files.

Read More
Backup Reliability

SQL SERVER – Check Backup Reliability

February 10, 2021
Pinal Dave
SQL Tips and Tricks
SQL Backup, SQL Restore, SQL Scripts, SQL Server

Recently I was asked by one of my clients of Comprehensive Database Performance Health Check recently asked if there is any way to Check Backup Reliability.

Read More
Database with T

SQL SERVER – Attach an In-Memory Database with T-SQL

December 21, 2020
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Backup, SQL Restore, SQL Scripts, SQL Server

My client of Health Check sent me an email asking if there is any other method when we have to attach an In-Memory Database with T-SQL.

Read More
Previous 1 2 3 4 5 … 19 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2025 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version