Restoring a database using STOPATMARK
This post will demonstrate how to restore a database from a log file up to a certain LSN (typically the one right before…
Read MoreCategory: Recovery
What is a .TUF file in the DATA folder?
The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…
Read More
Using the KILL command
You can view the status of a KILL command used to stop an open transaction by typing the following:
|
1 |
KILL [SPID] WITH STATUSONLY |
Views – 2067
Read More
Resolving the “Backup detected log corruption in database”
I saw this in the SQL logs today. It looks like some corruption happened in the transaction log of a specific database. I…
Read More
MSDB is in “Recovery Pending” state
I had a SQL Server at work today where I found the msdb database in “Recovery Pending” state. After reading a number of…
Read More
Shrinking TempDB and what to do when it doesn’t
This post is based on Tara’s recent blog post over on Brent Ozar’s site: and another: Basically, a query is killing your tempDB.…
Read More
Expiring Database Backups
The “Backup set will Expire” option is used to indicate how long a backup should be prevented from being over written by another…
Read More
PASS 2015 – Seattle WA – Day 3
PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…
Read More
PASS 2015 – Seattle WA – Pre-Con Day 2 – Dmitri Korotkevitch
PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…
Read More
Resolving Failover Log-shipping errors
Here is an error I recent received when failing-over our databases at work from our Primary SQL Server to our Secondary during a…
Read More