Tag Archives: administration

Saving Emergency Space on my Laptop

Posted on September 11, 2024 by way0utwest

With my new laptop, one of the things I realized I’d forgotten to do in setup is reserve some space. I wrote about this years ago, but I wanted to ensure I always had space in the event of an … Continue reading →

Posted in Blog | Tagged , | Comments Off on Saving Emergency Space on my Laptop

Fixing DBCC CloneDatabase Dup Key error in sys.sysschobjs

Posted on July 15, 2024 by way0utwest

This was an interesting error, and I was able to duplicate it, so I decided to write a post on how to find the problem and fix it. The error after running DBCC CLONEDATABASE is: NO_STATISTICS and NO_QUERYSTORE options turned … Continue reading →

Posted in Blog | Tagged | 3 Comments

An Upgrade Slog

Posted on July 8, 2024 by way0utwest

I saw a blog post from Randolph West recently that asked How do you restore a SQL Server 2000 database in the year 2024? It’s a bit of a process, involving an intermediate version and two restores. Randolph also points … Continue reading →

Posted in Editorial | Tagged | Comments Off on An Upgrade Slog

Inside SQL Server Backup and Restore History Pruning with sp_delete_backuphistory

Posted on July 3, 2024 by way0utwest

I had a customer that was looking to document a restore that had occurred on one of their systems and didn’t see it. They had concerns about SQL Server accurately tracking history across time and noted they hadn’t cleaned any … Continue reading →

Posted in Blog | Tagged , , , | 1 Comment