Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Log Shipping Rss

   Items 1 to 20 of 31    Older >>
 

Fix SQL Server Log Shipping After a New Database File has been Added

The code in this tip will demonstrate how to continue SQL Server Log Shipping after a file has been added to the primary SQL Server database.   Read more...
By Additional Articles 2014/02/05 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,343 reads

Repairing a Broken Log Shipping Plan From a Differential Backup

This article details how to reinitialise a Log Shipping scenario from a primary differential backup  Read more...
By Perry Whittle 2013/12/20 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: differential
Rating: |  Discuss |   Briefcase | 3,173 reads

Helping Streamline Log Shipping Failovers

Using Log Shipping? Looking for a more automated way to fail over during a disaster? Read on...  Read more...
By Micah Nikkel 2013/12/03 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 710 reads

Steps to rollback database changes without impacting SQL Server Log Shipping

When pushing a major release to a large production database, you want to know that you'll be able to rollback changes if the need arises. These are some simple steps which we can follow to ensure that we don't have to reconfigure log shipping all over again thereby saving time and ensuring systems are not affected when rolling back changes.   Read more...
By Additional Articles 2013/10/23 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 3,194 reads

Log Shipping Lite with PowerShell

A PowerShell driver that performs incremental restores on a standby server, a lite weight log shipping solution.  Read more...
By Paul Brewer 2013/07/01 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,949 reads

Adding new files to a log-shipped database (SQL Spackle)

Freshly minted MCM Wayne Sheffield fills a log shipping crack that could otherwise cause you to re-initialize your log shipping.  Read more...
By Wayne Sheffield 2013/06/06 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,539 reads

How to move a SQL Server Log Shipped Secondary Database to Different SQL Server

This tip I will explains a step-by-step method to perform the SQL Server Log Shipping migration.  Read more...
By Additional Articles 2013/03/04 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,731 reads

Adding new data files to a log shipped database

I ran into an interesting problem recently. There is a 4TB database that is log shipped to a DR site,...  Read more...
By Wayne Sheffield 2013/01/28 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 934 reads

Log Shipping - Monitor Server

By Raghavendra Mudugal 2012/12/05 | Category: log shipping
Rating: (not yet rated) |  Discuss |   Briefcase | 1,736 reads

Steps to add Log Shipping monitor into an existing SQL Server

I have a requirement to add the Log Shipping Monitor for an existing installation. I have heard you can only complete this by rebuilding the Log Shipping infrastructure. Is that true? Are there any other options? In this tip I will explain how we can add the Log Shipping monitor to a SQL Server 2005, 2008, 2008 R2 or 2012 environment without rebuilding the Log Shipping installation.  Read more...
By Additional Articles 2012/12/05 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,848 reads

Repairing a Broken Log Shipping Plan From a Differential Backup

This article details how to reinitialise a Log Shipping scenario from a primary differential backup  Read more...
By Perry Whittle 2013/12/20 (first published: 2012/09/27) | Source: SQLServerCentral.com | Category: differential
Rating: |  Discuss |   Briefcase | 3,173 reads

Log Shipping - How you can convert the secondary database into primar

This topic explains the log shipping if the primary database is suspected or corrupted and how you can convert the secondary database into primary database.   Read more...
By Muthu Gopalan 2012/04/27 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 874 reads

Setup database mirroring and log shipping together

SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they...  Read more...
By 2012/04/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,808 reads

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.  Read more...
By Luke Campbell 2012/03/15 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 4,243 reads

SQL Server Log Shipping Between Standalone\Workgroup Computers

This article describes the requirements to log ship databases between workgroup computers  Read more...
By Perry Whittle 2012/01/30 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,754 reads

SQL Server Log Shipping to a Different Domain or Workgroup

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.  Read more...
By Additional Articles 2012/01/13 | Source: MSSQLTips.com | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 1,653 reads

How to Setup Log Shipping for Multiple Databases

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.  Read more...
By Brian Davey 2011/09/28 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 4,691 reads

SQL Server Log Shipping For Large Databases

In this article you will see the detailed steps needed to implement the log shipping for large databases.  Read more...
By Additional Articles 2011/09/23 | Source: SQL Server Performance | Category: log shipping
Rating: (not yet rated)  Rate this |   Briefcase | 2,517 reads

Convert Mirroring to Log Shipping

Describes how to convert database mirroring to log shipping in SQL 2005/2008.  Read more...
By Jeremy Egbert 2010/08/19 | Source: SQLServerCentral.com | Category: database mirroring
Rating: |  Discuss |   Briefcase | 5,445 reads

Migrating VLDB with Log Shipping

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.   Read more...
By Additional Articles 2010/08/05 | Source: SQLServerCentral.com | Category: log shipping
Rating:  Rate this |   Briefcase | 3,076 reads
   Items 1 to 20 of 31    Older >>
 
Tags
disaster recovery (dr) (7)    
high availability (ha) (7)    
administration (3)    
blogs (3)    
database mirroring (2)    
monitor server (2)    
sql server 2005 (2)    
sql server 2008 (2)    
7zip (1)    
backup / recovery (1)    
backup / restore (1)    
checkdb (1)    
compression (1)    
differential (1)    
dr (1)    
editorial (1)    
failover (1)    
gzip (1)    
integration services (ssis) (1)    
migration (1)    
powershell (1)    
resolve logins (1)    
rollback (1)    
sharepoint (1)    
sql server 2008 r2 (1)    
warm standby (1)    
workgroup (1)    
zip (1)