Msg 3178 says a file is not in the correct state to have this differential backup applied to it. Here is how I reproduced it, and the fix.
SQL SERVER – FIX : Msg 8115, Level 16, Arithmetic Overflow Error Converting IDENTITY to Data Type INT
A SharePoint check-in failed with Msg 8115, Arithmetic Overflow Error converting IDENTITY to data type INT. How I found the table with Profiler and fixed it.
SQL SERVER – FIX: Msg 3132, Level 16 – The Media Set has 2 Media Families but Only 1 are Provided. All Members Must be Provided
RESTORE failed with Msg 3132: the media set has 2 media families but only 1 are provided. A repro of this striped backup error and how to restore correctly.
What is the Difference between TRUNCATE and DELETE in SQL Server? – Interview Question of the Week #118
What is the difference between TRUNCATE and DELETE in SQL Server? An interview question that never gets old, with a clear list of the differences.
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
How do you change owner of a database in SQL Server? Three ways, including ALTER AUTHORIZATION, which I prefer, and the deprecated sp_changedbowner.
SQL SERVER – Unable to Install Service Pack in Cluster – There was an Error to Lookup Cluster Resource Types
A service pack install in a cluster failed with: There was an error to lookup cluster resource types. Detail.txt pointed to the cause. Here is the fix.
SQL SERVER – Unable to recycle Errorlog – sp_cycle_errorlog – OS error 1392
On a clustered server the nightly ERRORLOG cycling stopped, and sp_cycle_errorlog failed with OS error 1392. Here is what that means and how we fixed it.