This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
A detached protected recovery case stands apart from the active cabinet and everyday workspace.

SQL SERVER – Ransomware Protection and Recoverable Offline Backups

May 16, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server, SQL Server Security

Ransomware recovery depends on protected backups and controlled access. I test whether those recovery copies survive the loss of normal systems.

Read More
SQL backup set expiration window.

SQL SERVER – Maintenance Plan – Backup Files Not Getting Deleted

May 5, 2017
Pinal Dave
SQL Tips and Tricks
Maintenance Plan, SQL Backup and Restore, SQL Server

A client’s maintenance plan ran fine, but old backup files were never deleted. The answer was in the documentation. Here is what to check.

Read More
Step-by-step differential backup diagram.

SQL SERVER – FIX : Msg 3178, Level 16 – File SQLAuthority is Not in the Correct State to have This Differential Backup Applied to it

April 25, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

Msg 3178 says a file is not in the correct state to have this differential backup applied to it. Here is how I reproduced it, and the fix.

Read More
SQL Server error message window.

SQL SERVER – FIX: Msg 3132, Level 16 – The Media Set has 2 Media Families but Only 1 are Provided. All Members Must be Provided

April 22, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

RESTORE failed with Msg 3132: the media set has 2 media families but only 1 are provided. A repro of this striped backup error and how to restore correctly.

Read More
Success in Backup Operations.

SQL SERVER – Msg 3035, Level 16 – Cannot Perform a Differential Backup for Database “SQLAuthority”, Because a Current Database Backup Does not Exist

April 19, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Server

Msg 3035 says you cannot perform a differential backup because a current database backup does not exist. My client had a full backup, so what went wrong?

Read More
Differential backups flowchart.

SQL SERVER – Msg 3136, Level 16 – This Differential Backup Cannot be Restored Because the Database has not Been Restored to the Correct Earlier State

April 5, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

I was trying to teach copy-only backups to my students and encountered below error related to differential backup.

Read More
SQL AUTHORITY' TOOL WINDOW ERROR.

SQL SERVER – Msg 3101, Level 16 – Exclusive Access Could not be Obtained Because the Database is in Use

April 4, 2017
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Server

RESTORE failed with Msg 3101: exclusive access could not be obtained because the database is in use. How to find who is connected and your options to fix it.

Read More
Previous 1 … 13 14 15 16 17 18 19 … 52 Next
  • Books
  • Testimonials
  • Privacy Policy

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