Recovering data in SQL Server without full backup

There are multiple reasons for no full backup: corrupted backups, taking too much time to restore, etc. In this post, I want to show an alternative for these cases, an ace up one’s sleeve, that you can use to recover data.

Removing a File

The Minimal Linked Server

Removing Log Shipping

Secondary Query Store

The Long Running Backup

Database Files on Shares I

Using the Default Trace in SQL Server

I have heard of the default trace in SQL Server. I know it’s on by default, but I don’t know how to use it. What can I do with the default trace?

Killing a SPID and Checking Rollback progress in SQL Server

From time to time, I encounter blocking situations where I end up issuing a SQL KILL command against the blocking SPID. When I run sp_who2, I can see the killed SPID is in a ROLLBACK state. Is there any way I can get an idea of how long the rollback for the SPID will take?

Rolling Back CUs