How long has this worked, and why didn’t anyone tell me? A typical restore statement from a FULL backup and a LOG backup: USE [master] RESTORE DATABASE [XE_demo] FROM DISK = N'D:BackupsKBH-Precision_SQL2016KBH-PRECISION$SQL2016XE_demoFULLKBH-PRECISION$SQL2016_XE_demo_FULL_20220511_092333.bak' WITH FILE = 1, NORECOVERY, NOUNLOAD, STATS = 25, REPLACE RESTORE LOG [XE_demo] FROM DISK = N'D:BackupsKBH-Precision_SQL2016KBH-PRECISION$SQL2016XE_demoLOGKBH-PRECISION$SQL2016_XE_demo_LOG_20220511_092414.trn' WITH FILE = 1, NOUNLOAD, STATS…
The post Restore Database or Restore Log? appeared first on DallasDBAs.com.