MSSQL 이전 데이터 복구

최초 Full Backup A.bak 

데이터 실수 가정 후 Full Backup B 파일

--Simple 모드 Backup이 아닌 FullBacpup으로 delete 전 A.bak 생성 
--Delete 명령어 사용 후 B 파일 생성  
backup log insu_product to disk = 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup\B.trn'
Go

--master 사용자로 실행 
--DB속성 -> 옵션 -> 상태 -> RESTRICTED_USER(제한된 사용자로 변경) 

Restore DATABASE insu_product from DISK ='C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup\A.bak'

with REPLACE, NORECOVERY,
MOVE 'insu_product' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup\B.mdf',
MOVE 'insu_product_log' TO 'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup\B.log.ldf'
Go


RESTORE LOG insu_product_B from DISK = N'C:\Program Files\Microsoft SQL Server\MSSQL14.SQLEXPRESS\MSSQL\Backup\B.trn' with NORECOVERY, STOPAT = '2021-10-11 15:05:49'
Go

 RESTORE DATABASE insu_product_B with RECOVERY