Blog Post

Restore Database or Restore Log?

,

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.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating