Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Scripts with tag Log Shipping Rss

Search for any content tagged log shipping

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Add a script

   Items 1 to 3 of 3   
 

Faster Log Shipping Restores

When you’re reading from a log shipped secondary, you want the duration of restores to be as short as possible. The sproc provided switches the restores to “NORECOVERY” mode, and then switch back to “STANDBY” at the end of the process.   Read more...
By Richie Lee 2015/12/11 | Source: SQLServerCentral.com | Category: log shipping
Rating: (not yet rated) |  Discuss |   Briefcase | 696 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 | 955 reads

Zip Backups and Copy to Secondary (free)

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.   Read more...
By Jeff Bennett 2009/06/18 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 2,441 reads
   Items 1 to 3 of 3