KOREAN -------------
실행 전 주의 사항 -3. 복원의 DB명은 미리 생성하지 말것(Unique DB Name)
1. 확인1
RESTORE HEADERONLY FROM DISK = '(A)backup file path and file name'
2. 확인2
RESTORE FILELISTONLY FROM DISK = '(A)backup file path and file name'
3. 복원
RESTORE DATABASE DB명(확인1에 DatabaseName컬럼)
FROM DISK = '(A)backup file path and file name'
WITH MOVE '(C)논리명(확인2에 logicalname)' TO '(E)D:\DATA파일경로\파일명.MDF',
MOVE '(D)논리명(확인2에 logicalname)' TO '(F)D:\LOG파일경로\파일명.LDF'
(A)backup file path and file name
--> 백업 파일의 원본 위치
(B)DBName
--> 유일한 이름의 디피명 (먼저 복원할 디피명을 생성하지 말것)
(C)logical DATA name
--> 확인2의 logicalname컬럼(DATA)을 입력하면 됨(복수일시 Move절 수만큼 반복해서 기입)
(D)logical LOG name
--> 확인2의 logicalname컬럼(LOG)을 입력하면 됨(복수일시 Move절 수만큼 반복해서 기입)
Statement')
(E)D:\DATA Path\DATA File.MDF
--> 저장하길 원하는 경로및 파일명(자동생성됨)
(F)D:\DATA Path\DATA File.LDF'
--> 저장하길 원하는 경로및 파일명(자동생성됨)
English --------------
1. Confirm Infomation 1 (C1)
RESTORE HEADERONLY FROM DISK = '(A)backup file path and file name'
sample) 'C:\vinsPrivate\vins\database-backup.bak'
2. Confirm Infomation 2 (C2)
RESTORE FILELISTONLY FROM DISK = '(A)backup file path and file name'
3. Restore
RESTORE DATABASE (B)DBName(DatabaseName Column in C1)
FROM DISK = '(A)backup file path and file name'
WITH MOVE '(C)logical DATA name' TO '(E)D:\DATA Path\DATA File.MDF',
MOVE '(D)logical LOG name' TO '(F)D:\DATA Path\DATA File.LDF'
(A)backup file path and file name
--> bak file and path
(B)DBName
--> Unique DATABASE Name (there is not DATABASE NAME Always)
(C)logical DATA name
--> logicalname in C2 (if Logical DATA was mutiful, you are going to write 'MOVE Statement')
(D)logical LOG name
--> logicalname in C2 (if Logical LOG was mutiful, you are going to write 'MOVE Statement')
(E)D:\DATA Path\DATA File.MDF
--> It's saving file and path, you want
(F)D:\DATA Path\DATA File.LDF'
--> It's saving file and path, you want
