Database Transaction log file full in the full recovery model
AdvertisementsI am seeing in more environment the database recovery model is set FULL and there is no transaction log backup...
2018-10-16
301 reads
MUTHUKKUMARAN KALIYAMOORTHY
- Interests: Playing cricket,Reading,Dancing...
- Website: https://sqlserverblogforum.com
AlwaysON RECOVERY PENDING SQL Server Bugs Enhancement Requests T-SQL Tuesday
AdvertisementsThis month’s T-SQL Tuesday topic is “SQL Server Bugs & Enhancement Requests” and hosted by my favorite and inspirational Brent Ozar.
Here...
2017-01-10
587 reads
AlwaysON database not synchronizing mode SQL service account change
AdvertisementsAlwaysON database not synchronizing mode SQL service account change
Suddenly, one of our alwaysON server databases are went not synchronizing mode.
Errors...
2016-11-24
2,616 reads
AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
AdvertisementsAlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
I have recently come across an issue that, one of my alwaysON secondary replica...
2016-08-16 (first published: 2016-08-06)
16,402 reads
AlwaysON move database without breaking HADR
AdvertisementsMove database without breaking alwaysON
This post is going to show the database movement from one drive to another drive, without...
2016-08-08 (first published: 2016-08-03)
15,895 reads
Lost Administrator SA password SQL server 2012
AdvertisementsThere are many blog posts talking about, how to recover “SysAdmin” password in case if it’s lost OR the server...
2014-08-01 (first published: 2014-07-27)
15,906 reads
An application error occurred on the server running on SQL server
AdvertisementsRecently one of my application website went down.
I checked all the basic connectivity troubleshooting and seem everything was looking and...
2013-11-25
1,389 reads
Login failed for [SQLSTATE 28000] (Error 18456) the step failed
AdvertisementsLogin failed for [SQLSTATE 28000] (Error 18456) the step failed
When you query the data from another SQL server (Linked server)...
2012-06-18
53,703 reads
SQL server failed to start the system cannot find the path specified
AdvertisementsRecently one of our SQL server unable to start it. The problem with the storage LUNs.
Things you have to do:...
2012-04-09
6,365 reads
Find the latest databse backup SQL server
AdvertisementsUse the simplest script to find the latest database backup and the location.
-- To get the backup history
SELECT top 100...
2012-03-05
872 reads
Blogs
Fighting Procrastination?
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
A Fun Prize at the PASS Data Community Summit
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
How to Measure AI Value: A 6-Branch AI Maturity Model for Use Cases and Agents
Your AI is busy. But do you know what it's worth? Most companies can...
Forums
SQL Server 2025 Server-level Roles
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
Stairway to DAX and Power BI - Level 29: The DAX Combine & Aggregate Functions
Comments posted to this topic are about the item Stairway to DAX and Power...
AI Is Improving Security
Comments posted to this topic are about the item AI Is Improving Security
Question of the Day
SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers