Learning SQL Server Log Shipping? Check out these valuable tips, tutorials, how-to’s, scripts, and more ideal for SQL Server DBAs.
Webcast Abstract In a poll during a SQLBits Log Shipping webinar, DBAs sighted the following Disaster Recovery challenges, which we will address in this webinar: Traditional Backups, Log Shipping, and Failover Clustering methods for SQL Server often present challenges such…
Webcast Abstract Business continuity and disaster recovery plans are crucial for the continued existence of any organization. Whether it’s a malformed definition file that takes out a wide swath of computers worldwide, or a natural disaster like an earthquake or…
In this article we walk through the steps on how to implement SQL Server log shipping for SQL Server running on Linux systems.
In this tip we look at how to clean up old jobs and history data for a SQL Server log shipping configuration that was changed.
In this tip we look at methods to resync a SQL Server log shipped database quicker after a log shipping restore failure.
Check out these scripts that can be used to monitor log shipping with SQLCMD.
Learn the step by step process for SQL Server Log Shipping monitoring and email notification.
Learn how to change the SQL Server Log Shipping database from restoring Mode to standby mode in order to perform ad-hoc queries.
I wrote my last tip on How to change restore mode of a secondary database in SQL Server log shipping. In that tip I explained the need to the change of restore mode and demonstrated how to change it from restoring to standby mode. We used T-SQL comman
In this tip, I will explain the step by step process to change the secondary SQL Server database from NORECOVERY (restoring) to STANDBY (read only) without having to reinitialize the log shipping configuration.
I still use SQL Server Log Shipping to maintain a standby instance for some of my critical production databases. Any time I add a new file to my primary SQL Server database, log shipping breaks because the drive layout on the standby server is different
I have a production release for a database that has log shipping setup. The database is very large and I don't want to have to redo the entire log shipping setup again if I have a problem with the release and I need to roll back the changes. In this tip
With SQL Server is it possible to move the secondary database involved with Log Shipping to a different drive without disturbing the Log Shipping configuration? If so, what are the steps to accomplish this task? Check out this tip to learn more.
We recently got multiple out of sync alerts for one of our log shipped databases which became out of sync because a new database file was added to the primary database. When we checked the error log, log shipping was not able to apply the remaining log ba
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 a
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. T
Log shipping has been an option for creating a failover server for SQL Server for quite some time. In this tip, we look at different ways that you can monitor the status of your log shipped databases.
In this tip we walk through the steps to setup SQL Server Log Shipping.
When failing over to a standby server in a log shipping pair, we need to restore the latest transaction log backup to make the standby databases ready for access. This process may be cumbersome if it involves manually restoring more than five database in
SQL Server log shipping overview.