Adding a log shipping monitor
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,064 reads
This article describes how to add a log shipping monitor to a log shipping configuration that is already in place.
2012-03-15
7,064 reads
This article describes the requirements to log ship databases between workgroup computers
2012-01-30
5,412 reads
Sometimes the requirement arises to provide a copy of your database to an off-site location, such as a disaster recovery datacenter. Log Shipping is one of the most popular, proven technologies used to create a copy of your databases on a remote server.
2012-01-13
2,334 reads
This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.
2011-09-28
11,510 reads
In this article you will see the detailed steps needed to implement the log shipping for large databases.
2011-09-23
2,889 reads
2011-06-08
2,364 reads
You just had a great weekend. You go grab your coffee and before you take a sip a manager grabs you and says, "we need your help." We need to migrate a very large database to our new data center. We need to keep the data in sync and have a short period of downtime when we cutover.
2010-08-05
3,477 reads
Longtime author Leo Peysakhovich has implemented a log shipping mechanism that can recover from failures and give you control over how it works. Read on if you want to implement your own version of log shipping and have control over all aspects of the process.
2010-07-01
5,874 reads
We discovered a need to compress our backups so that we could copy the files over the network to the DR location (log shipping), to save on transfer time during emergency restores.
2009-08-03 (first published: 2009-06-05)
2,510 reads
New author Brian Bitzer brings us a solution to a log shipping problem in the Real World. Read about jhow one DBA solves a contention issue using SSIS.
2009-01-20
4,129 reads
I am responding late to a T-SQL Tuesday invite from John Sterrett. John’s call...
It’s been forgotten about and neglected for few years but I’ve decided to dust...
I am honored to announce that I have been renewed as a Microsoft MVP...
Comments posted to this topic are about the item How a Legacy Logic Choked...
Comments posted to this topic are about the item People Make Odd Choices
Comments posted to this topic are about the item SQL Server 2022 Clusterless Distributed...
For the Question of the day, I am going to go deep, but try to be more clear, as I feel like I didn't give enough info last time, leading folks to guess the wrong answer... :) For today's question: You’re troubleshooting a performance issue on a critical stored procedure. You notice that a previously efficient query now performs a full table scan instead of an index seek. Upon investigating, you find that an NVARCHAR parameter is being compared to a VARCHAR column in the WHERE clause. What is the most likely cause of the query plan regression?
See possible answers