Log-shipping – LincolnBlog.net

The TUF files you see in the ..\DATA folder is a “transaction undo file” which contains modifications to the database that were not…

Questions: 1. Does TR copy schema changes? (It does not. It’s a lot like CDC in many ways) Setup Transaction Replication in SQL…

I have had a number of situations where log-shipping broke and I needed to rebuild it but could not drop the log-shipping configuration…

I sometimes need to rebuild the log-shipping for a database and if it is a large database the windows dialogs only display the…

PASS 2015 10-27-30 Seattle WA Pre-Con Day 2 – SQL Server Internals – The Practical Angle Dmitri Korotkevitch Data Storage 101 Data Pages…

I recently had a scenario where I wanted to drop a database (it was replaced by a new system) on a primary SQL…

Here is an error I recent received when failing-over our databases at work from our Primary SQL Server to our Secondary during a…

You can validate the status of log-shipping to a secondary server if you suspect it has been broken. Below is the script, which…

Here is a good article on syncing SQL logins across servers with the same SIDS to log-shipped databases will propagate the correct access…

Here are a few SQL commands that you can use if you simply want to delete a database that is in “Recovering” or…

LincolnBlog.net