Recover database without LDF file

I recently came across a missing LDF file case that I would like to share some interesting findings. In my case, the customer didn’t have any database backup (they did have maintenance plan created, however, the job had been being failing since the day it was implemented. Another sad story telling us how important to…


Troubleshooting intermittent connection timeout

In this blog, we are going to take a deep dive into a connectivity issue my customer encountered a while ago. DBA was pulled into this case because the error was caused by SQL Server connection timeout. We looked at SQL Server log and there was no messages about connection failure. The issue turned out to…


SQL 2016 – Temporal Tables – What are they and how do you set one up?

What are Temporal Tables?   This is the start of a series of posts about one of my favorite new features of SQL 2016, Temporal Tables.  Temporal Tables allow you go back in time and see what the data in table looked like at that point in time.  Unlike the movie series Back to the Future, you…

3

Performing transaction log backups using AlwaysOn Availability Group read-only secondary replicas-Part2

Describe the log backup process on a ROSR This is the second post in a planned series of articles relating to SQL Server transaction log backups of databases using a read-only secondary replica (ROSR).  Since the introduction of ROSRs in SQL Server 2012, administrators have been able to perform full database (copy only) backups as…

2

Performing Transaction Log Backups using AlwaysOn Availability Group Read-Only Secondary Replicas – Part 1

This is the first post in a planned series of articles relating to SQL Server Transaction Log Backups of databases using a read-only secondary replica (ROSR).  With the introduction of ROSRs in SQL Server 2012, administrators can now perform full database (copy only) backups as well as transaction log backups on one of the secondary…

0

Finding Which Connections Have Been Read Only Routed

This is a follow up to my first post Finding What Availability Group Listeners Applications Are Using To Connect, where a question was posed about knowing which connections have been read only routed. Background Information SQL Server Availability Groups allow for something called “Read Only Routing” which allows for severs that are currently a secondary…

0

Create a Quick and Easy Performance Baseline

In this blog post I am going to discuss a very little-known performance metric introduced in SQL Server 2012 that you can use to instantly get a baseline of the query performance for your system.  The counters I’m referring to are under the Performance Monitor (perfmon) group SQLServer:Batch Resp Statistics (this name may be slightly…

0

TCP Port Is Already In Use

It’s 3 AM on a Saturday morning and you receive that dreaded phone call – “The SQL Server just had maintenance. We rebooted and now SQL won’t start”! You dig into the error logs and see something like this:     2016-07-12 22:41:20.58 spidxxs Server TCP provider failed to listen on [ ‘any’ <ipv6> 1433]. Tcp…