Get SQL Server log shipping functionality without Enterprise Edition
A new tip of mine has just been published on SearchSQLServer.com. This tip, “Get SQL Server log shipping functionality without Enterprise Edition” is all about writing your own Log Shipping code without using Microsoft’s, allowing you to use Log Shipping on editions of SQL Server other than Enterprise Edition. Denny
Getting more error data from SQL Server Replication
The error reporting in SQL Server Replication isn’t all that great. This is a well known issue that pretty much everyone knows about. Something that I don’t know if a whole lot of people know about, is that there is a way to get a lot more information from replication about what’s going on, and what’s going wrong.
Read on for more information.
Don’t Consolidate Yourself Into Performance Problems – Archive
The webcast which I did for Quest Software called Don’t Consolidate Yourself Into Performance Problems is now available for viewing after the fact. This is the webcast which I did last week for Quest Software. It you had signed up for the session Quest should have sent you an email with this URL already. Thanks, Denny
How to setup a server to read log files nightly.
So you’ve been tasked with setting up a quick and dirty reporting server. The goal is to restore the log files from the production server to the reporting server nightly. The backups are simple, use the SQL Maintenance plan to backup the logs, and then copy them to the remote machine. But how do you […]