Tag Archives: administration

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

Xp_cmdshell Use Cases

Posted on July 3, 2024 by way0utwest

I had someone ask me recently how to run xp_cmdshell on a Linux version of SQL Server. I told them you can’t, as it’s an unsupported feature and not one that I expect to see released. I had to double-check, … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Xp_cmdshell Use Cases