My database is in the recovery pending state and I want to get in and extract the data out into a new database, I have NO BACKUPS available so some data (even if it is dodgy) is better than nothing.
Corrupt Database – I need that data now!
3
Extreme situations require extreme commands
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is my entry for this month’s T-SQL Tuesday found: http://www.pontop.dk/single-post/2017/03/07/Announcing-T-SQL-Tuesday-88-%E2%80%93-The-daily-database-related-WTF
Copying your SQL Database
If you ever need to move a copy of a SQL database in Azure across servers then here is a quick easy way.
Tempdb settings in SQL Server
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb.
Tempdb settings in SQL Server 2016
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb.
All About Tech 