Apr 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
full-due-to-replication

SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’

March 23, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Log, SQL Replication, SQL Scripts, SQL Server, Transaction Log

In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.

Read More
maxsize

SQL SERVER – Msg 1842 – The File Size, Max Size Cannot be Greater Than 2147483647 in Units of a Page Size

March 19, 2020
Pinal Dave
SQL Tips and Tricks
File Growth, SQL Error Messages, SQL FileGroup, SQL Log, SQL Scripts, SQL Server, SQL Server Configuration

Could not allocate space for an object because the ‘PRIMARY’ filegroup is full and The File Size, Max Size Cannot be Greater Than 2147483647

Read More
authentication

SQL SERVER – Why Server Authentication is Disabled? What Mode is SQL Server Using Currently?

March 18, 2020
Pinal Dave
SQL
SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration, SQL Server Security

I would share my learning about the cause of Server Authentication mode disabled. If it is disabled, how would you know what mode is used by SQL Server?

Read More
GetToken

SQL SERVER – LogonUserExEx Fails for User & GetToken – Logging on as the CNO Failed With Error 1326

March 17, 2020
Pinal Dave
SQL
AlwaysOn, SQL Error Messages, SQL Server, SQL Server Cluster, SQL Server Security

In this blog I would share my learning about fixing error LogonUserExEx fails for user & GetToken – Logging on as the CNO failed with error 1326.

Read More
External Data Sources

SQL SERVER – PolyBase Error Msg 46530 – External Data Sources Are Not Supported With Type GENERIC

March 16, 2020
Pinal Dave
SQL
PolyBase, SQL Error Messages, SQL Scripts, SQL Server, SQL Server Configuration

In this blog, I would share my findings of error Msg 46530 – External data sources are not supported with type GENERIC. Let us read more…

Read More
frozen

SQL SERVER – What do These Messages Mean – “I/O is Frozen on Database” and “I/O was Resumed on Database”?

March 14, 2020
Pinal Dave
SQL
SQL Backup, SQL Error Messages, SQL Server, Starting SQL, System Database

  “I/O is frozen on database” and “I/O was resumed on database”? Did you check the air conditioner temperature? Let us learn about it in today’s blog post.

Read More
process ID

SQL SERVER – Msg 17177 – This Instance of SQL Server Has Been Using a Process ID of %s since %s (local) %s (UTC)

March 9, 2020
Pinal Dave
SQL Tips and Tricks
SQL Azure, SQL Error Messages, SQL Log, SQL Server, SQL Server Security, SQL Server Services

In this blog today, I would share my understanding of the message “This instance of SQL Server has been using a process ID of”

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

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

Go to mobile version