anydragon

mac, linux, aws, c, c++, mysql, mssql, redis, csharp, nodejs, rust, golang

ms sql 데이타베이스 복원방법

— 백업생성(있으면 생략)

BACKUP DATABASE Northwind
TO DISK = 'c:\Northwind.bak'

1 2	BACKUP DATABASE Northwind TO DISK = 'c:\Northwind.bak'

–백업정보확인(논리적파일명, 물리적저장위치및파일명 확인)

RESTORE FILELISTONLY
FROM DISK = 'c:\Northwind.bak'

1 2	RESTORE FILELISTONLY FROM DISK = 'c:\Northwind.bak'

— TestDB라는 새로운 데이터베이스로 새로운 경로(C:\temptest*.*)으로 복원

RESTORE DATABASE TestDB
FROM DISK = 'c:\Northwind.bak'
WITH MOVE 'Northwind' TO 'c:\testtestdb.mdf',
MOVE 'Northwind_log' TO 'c:\testtestdb.ldf'

RESTORE DATABASE TestDB

FROM DISK = 'c:\Northwind.bak'

WITH MOVE 'Northwind' TO 'c:\testtestdb.mdf',

MOVE 'Northwind_log' TO 'c:\testtestdb.ldf'