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
Restore Command

SQL SERVER – Add Database to Availability Group Failure – This BACKUP or RESTORE Command is Not Supported on a Database Mirror or Secondary Replica

June 28, 2019
Pinal Dave
SQL Tips and Tricks
AlwaysOn, SQL Backup and Restore, SQL Error Messages, SQL High Availability, SQL Scripts, SQL Server, SQL Server Management Studio

In this blog post, we will fix the error related to This BACKUP or RESTORE command is not supported on a database mirror or secondary replica.

Read More
Memory Optimized Tables

SQL SERVER – Memory Optimized Tables, Transactions, Isolation Level and Error

June 11, 2019
Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Error Messages, SQL Memory, SQL Scripts, SQL Server, SQL Transactions, Transaction Isolation

Today we will see an interesting story about Memory Optimized Tables, Transactions, Isolation Level and Error. Let us read the blog post.

Read More
SQL SERVER - FIX: Msg 15274 - Access to the Remote Server is Denied Because the Current Security Context is not Trusted

SQL SERVER – FIX: Msg 15274 – Access to the Remote Server is Denied Because the Current Security Context is not Trusted

June 3, 2019
Pinal Dave
SQL Tips and Tricks
Linked Server, SQL Error Messages, SQL Server, SQL Server Security

In this blog we would talk about fixing error 15274 – Access to the remote server is denied because the current security context is not trusted.

Read More
primary file

SQL SERVER – Error: 5173 – One or More Files do Not Match the Primary File of the Database

June 1, 2019
Pinal Dave
SQL Tips and Tricks
SQL Data Storage, SQL Error Messages, SQL Server

In this blog, we would discuss error: Error: 5173 – One or more files do not match the primary file of the database and its solution.

Read More
Title card: REBUILDDATABASE Error: 0x84CF0004

SQL SERVER – REBUILDDATABASE Error: 0x84CF0004 – While updating permission setting for folder The Permission Setting Update Failed for File

May 31, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Server, SQL Server Security

While updating the permission setting for the folder, the permission setting update failed for the file with the error REBUILDDATABASE.

Read More
Title card: REBUILDDATABASE Error 0x851A0012: Missing sa Password

SQL SERVER – REBUILDDATABASE Error: 0x851A0012 – Missing sa Account Password. The sa Account Password is Required for SQL Authentication Mode

May 25, 2019
Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Login, SQL Server, SQL Server Security

The plan was to first rebuild system databases and then restore ALL databases from the backup. Today we will discuss an error about REBUILDDATABASE.

Read More
conflicting

SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name

May 24, 2019
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Error Messages, SQL Server

In this blog we would learn how to fix Msg 4353 – Conflicting file relocations have been specified for the file. We solve this error very quickly.

Read More
Previous 1 … 8 9 10 11 12 13 14 … 117 Next
  • Books
  • Testimonials
  • Privacy Policy

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