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,040 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,363 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,833 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,508 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,070 reads
Reduce your recovery time and minimize the chance for error by resolving all logins in one script.
2008-06-03
15,175 reads
This article presents a way to implement a simple database synchronization solution similar to log shipping using Database Maintenance Plans and T-SQL.
2008-05-01
7,126 reads
Look, we all know data is king these days. But having mountains of data...
This topic keeps coming up with my customers so the purpose of this blog...
By Steve Jones
I realized that I hadn’t done much blogging on Window functions in T-SQL, and...
Hi, how to send emails on Azure Hyperscale server and which sp we...
I was trying to access SSRS report in host server browser , throwing an...
Sorry, more bakery stuff. Say I buy ingredients over time and I want to...
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers