Convert Mirroring to Log Shipping
Describes how to convert database mirroring to log shipping in SQL 2005/2008.
2010-08-19
6,092 reads
Jeremy Egbert
Repair Corruption Using the Mirror Database in SQL 2005
Explanation of how to repair a database in SQL 2005 Enterprise which is mirrored.
2010-05-10
4,395 reads
Script to Compress Tables and Indexes
This script creates scripts to compress all tables and indexes in a database.
2010-01-04 (first published: 2009-12-11)
15,834 reads
Blogs
Houston AI-Lytics 2026–Powerpoint Slides
By Steve Jones
Thanks to everyone for attending my session on running a Local LLM. If you...
The Book of Redgate: Do the Right Things
By Steve Jones
I do believe that Redgate has been very customer focused since it’s inception. I’ve...
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Forums
Warning: Could not open global shared memory to communicate with performance DLL
Hi everyone I am getting below warning when I run SSIS: Warning: 0x80049304 at...
Let's Talk Community Events!
Comments posted to this topic are about the item Let's Talk Community Events!
that one limitation in replication
Hi as shown below a replication target requires a primary key. if we want...
Question of the Day
Detecting Deadlocks
By default, how often is the SQL Server Database Engine checking for deadlocks?
See possible answers