A log shipping alternative for a database in the simple recovery model is a second copy that restores the newest full backup and the newest differential backup. This post finds those two files from the backup history in msdb, restores them with MOVE and RECOVERY, and repeats the cycle on a schedule. It also states what you lose compared with real log shipping.
SQL Server – How to Get Column Names From a Specific Table?
I get column names from schema-qualified table metadata. Catalog views help when I also need SQL Server-specific details.
SQL SERVER – Puzzle – Incorrect Results with Decimal
A new puzzle: a simple table with price and discount returns Incorrect Results with DECIMAL. Can you work out why without running the code in SSMS?
SQL SERVER – FIX: Msg 3009, Level 16 – Could not Insert a Backup or Restore History Detail Record in the msdb Database
A slow restore that my client cancelled led to Msg 3009: could not insert a backup or restore history record in msdb. Here is what I learned about a trace flag.
What is Copy Only Backup in SQL Server? – Interview Question of the Week #128
Copy Only Backup is an independent backup that does not break the LSN chain or disturb your regular backup plan. Here is the short answer and a longer one.
SQL SERVER – FIX: Msg 15170, Level 16, This login is the Owner of 1 Job(s). You Must Delete or Reassign these Jobs Before the Login can be Dropped
Msg 15170: this login is the owner of 1 job(s) and cannot be dropped. Here is how to find those jobs and reassign them first.
SQL SERVER – Upgrade Failure – The Cluster Resource is Not Online. Bring the Analysis Services Server Online Before Starting the Upgrade Process
Upgrade and one need to evaluate them before making a final choice. Let us see an error related to Upgrade Failure. Let us learn today.