Skip to content
Getridbug
  • WordPress
  • Unix & Linux
  • Python
  • More
    • Android
    • ASP.NET
    • Database Administrators
    • Graphic Design
    • Laravel
    • Node.js
    • PHP
    • ReactJS
    • Webmasters
    • HTML
    • MySQL
    • Salesforce
    • Magento
    • Information Security
    • Computer Enthusiasts
    • Ubuntu
  • Contact Us
  • Paid Service paid service
Menu Close
  • WordPress
  • Unix & Linux
  • Python
  • More
    • Android
    • ASP.NET
    • Database Administrators
    • Graphic Design
    • Laravel
    • Node.js
    • PHP
    • ReactJS
    • Webmasters
    • HTML
    • MySQL
    • Salesforce
    • Magento
    • Information Security
    • Computer Enthusiasts
    • Ubuntu
  • Contact Us
  • Paid Service paid service

log-shipping

Home » log-shipping

Log Shipping "out of sync" but none of the jobs are failing

  • Post published:June 17, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. I've configured a log shipping from a server, to the same server, only with a different…

Continue ReadingLog Shipping "out of sync" but none of the jobs are failing

Log shipping large DBs – what about the log?

  • Post published:June 17, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. I'm currently setting up log shipping of a large DB (Approx 1.5TB) and am wondering what…

Continue ReadingLog shipping large DBs – what about the log?

After Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow

  • Post published:June 17, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. We've set up log shipping to a secondary SQL server on Standby/ Read-Only to offload all…

Continue ReadingAfter Restoring Log Shipping to Secondary Server, First Stored Procedure Execution is Slow

SQL Server Log Shipping: File copy options?

  • Post published:May 31, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. I usually use redgate sql backup which has a transaction log copy mechanism built in. If…

Continue ReadingSQL Server Log Shipping: File copy options?

Creating Users on secondary server in log shipping

  • Post published:May 25, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. I have a production Server say ServerA I have setup log shipping to ServerB which is…

Continue ReadingCreating Users on secondary server in log shipping

How does Log shipping know to keep track

  • Post published:May 25, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. I have set up log shipping between 2 SQL Servers (SQL Server 2008 and SQL Server…

Continue ReadingHow does Log shipping know to keep track

Remove the log shipping configuration on the secondary server, when the primary is no longer available

  • Post published:May 25, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. My primary server with SQL Server 2005 broke down, so I've started up the log-shipped database…

Continue ReadingRemove the log shipping configuration on the secondary server, when the primary is no longer available

Best way to migrate a huge SQL Server database with low downtime over network

  • Post published:May 25, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. Problem definition Our database server needs to be transferred to an other datacenter. It runs on…

Continue ReadingBest way to migrate a huge SQL Server database with low downtime over network

SQL Server logshipping: Extend the LS_Alert window

  • Post published:April 20, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. We have a logshipping setup, where the LS_Restore job on the secondary database is switched off…

Continue ReadingSQL Server logshipping: Extend the LS_Alert window

SQL Log Shipping – What is the date time format used by transaction log file name?

  • Post published:April 20, 2022
  • Post category:Database Administrators
  • Post comments:0 Comments

All we need is an easy explanation of the problem, so here it is. Looking at my SQL log shipping file names (following is an example) Q:\Backups\LogShipping\MyAudit\MyAudit_20201027165400.trn What date time…

Continue ReadingSQL Log Shipping – What is the date time format used by transaction log file name?
  • 1
  • 2
  • Go to the next page
  • Android
  • ASP.NET
  • Database Administrators
  • Laravel
  • Magento
  • WordPress
  • Unix & Linux
  • PHP
  • Python
  • Information Security
  • Graphic Design
  • ReactJS
  • Node.js
  • Webmasters
  • Computer Enthusiasts
  • AngularJS
  • HTML
  • Salesforce
  • MySQL
  • Ubuntu
  • Contact Us
  • Terms & Condition
  • Privacy Policy
  • Disclaimer
Copyright © 2022 GetRidBug. All Rights Reserved.