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...

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...

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...

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...

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...

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...

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...

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)...

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:...

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...