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
Growth rings in an established oak log beside a young sapling

How Old Version of SQL Server Running on Server? – Interview Question of the Week #183

July 22, 2018
Pinal Dave
SQL Interview Questions and Answers
SQL Patch, SQL Scripts, SQL Server

Is your server on an old version of SQL Server? Run SELECT @@VERSION to see the build and the date the patch was created, a check I often run during a Health Check.

Read More
Install error: validation for AGTSVCACCOUNT failed.

SQL SERVER – Install Error: Validation for Setting ‘AGTSVCACCOUNT’ Failed. Error Message: The RPC Server is Unavailable

July 21, 2018
Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages, SQL Server, SQL Server Installation

A command-line SQL Server install failed: Validation for setting ‘AGTSVCACCOUNT’ failed, the RPC server is unavailable. I read the setup log and found the fix.

Read More
SQL Server Install error dialog box.

SQL SERVER – Installation Error: The Specified Value ‘Install’ for ACTION is Invalid

July 20, 2018
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Log, SQL Server

A client’s command-line SQL Server install failed with: The specified value ‘Install’ for ACTION is invalid. Here is what the setup log showed and how to fix it.

Read More
Gouache painting of a warning sign on an interrupted backup bridge to cloud storage

Backup Error 3636: An Error Occurred While Processing BackupMetadata

July 19, 2018
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Backup and Restore, SQL Error Messages

Backup error 3636 appeared on a log backup taken on an availability group secondary after a log file was added on the primary. The secondary had not replayed the change. This post shows the queries I use to compare file lists and redo progress, tested on SQL Server 2025.

Read More
Sas Tool Window.

SQL SERVER – Backup to URL – Script to Perform Striped Backup using Shared Access Signature (SAS)

July 18, 2018
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Scripts, SQL Server

A reader wanted a striped backup to Azure Blob Storage. Here is my script to take a striped Backup to URL across several files using a SAS token credential.

Read More
SQL SERVER - Backup to URL - Script to Generate Credential and Backup using Shared Access Signature (SAS)

SQL SERVER – Backup to URL – Script to Generate Credential and Backup using Shared Access Signature (SAS)

July 17, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Scripts, SQL Server

Backup to URL can connect to Azure storage with a SAS token. I share a script that generates the credential and the backup command using a Shared Access Signature.

Read More
Gouache painting of a warning sign on an interrupted backup bridge to cloud storage

Msg 3292 in SQL Server: Failure Executing Backup or Restore With a URL Device

July 16, 2018
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Backup and Restore, SQL Error Messages, SQL Server

Msg 3292 appears when a backup or restore with a URL device fails, and it never names the cause itself. In one 2018 client case the cause was a renamed BackupToUrl.exe. This post shows how to read the companion messages, check the helper file and the credential, and trace the failure.

Read More
Previous 1 … 206 207 208 209 210 211 212 … 844 Next
  • Books
  • Testimonials
  • Privacy Policy

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