Browse the archive

Backup & Recovery

Error 3203 restoring SQL Server backup: The data is invalid

April 17, 20152 min read

Question I am trying to restore a .bak file (backup taken on SQL Server 2008 R2, compatibility level 100). I am restoring the backup on SQL Server 2012 edition. I get the below error. Unfortunately the original DB from where the DB was backed up is no longer …

Databases

SQL Server 2012 always-on backup, full vs copy-only

April 25, 20141 min read

Question I need a quick clarification on copy-only backup vs full backup as it pertains to transaction log numbering and restore if required. I have SQL Server 2012 setup with always on for multiple databases. The availability groups are setup with preferred …