MS-SQL

2000μ—μ„œ λ°±μ—…ν•˜κ³  2005μ—μ„œ ...

🩷 슈 🧑 2010. 5. 19. 11:27
728x90
SMALL
λ°±μ—…κ³Ό 볡원 λͺ¨λ‘ λ™μΌν•˜κ²Œ ν•˜λ©΄ λ©λ‹ˆλ‹€.
 

1. μœ μ§€κ΄€λ¦¬ λ§ˆλ²•μ‚¬λ₯Ό μ‚¬μš©ν•΄μ„œ λͺ¨λ“  λ°μ΄ν„°λ² μ΄μŠ€μ— 전체 백업을 λ°›κ³ ,
각 λ°μ΄ν„°λ² μ΄μŠ€ 백업을 SQL Server 2005μ—μ„œ 볡원가λŠ₯ν•©λ‹ˆλ‹€.
(단 2005의 백업을 2000에 볡원할 μˆ˜λŠ” μ—†μŠ΅λ‹ˆλ‹€.)
 
2. λͺ…λ Ήμ–΄ μˆ˜ν–‰
백업을 λͺ…λ Ήμ–΄λ‘œ μˆ˜ν–‰ν•˜μ‹œλ €λ©΄
BACUP DATABASE λ°μ΄ν„°λ² μ΄μŠ€λͺ… TO DISK = 'C:\TEMP\λ°μ΄ν„°λ² μ΄μŠ€λͺ….bak' WITH STATS = 10
볡원을 λͺ…λ Ήμ–΄λ‘œ μˆ˜ν–‰ν•˜λ €λ©΄
RESTORE DATABASE λ°μ΄ν„°λ² μ΄μŠ€λͺ… FROM DISK = 'C:\TEMP\λ°μ΄ν„°λ² μ΄μŠ€λͺ….bak' WITH STATS = 10

3. μ„œλΉ„μŠ€ 쀑단
λ°μ΄ν„°λ² μ΄μŠ€ 뢄리 --> 파일 볡사 --> λ°μ΄ν„°λ² μ΄μŠ€ μ—°κ²°λ‘œλ„ μ‰½κ²Œ λ°μ΄ν„°λ² μ΄μŠ€λ₯Ό 2005둜 μ΄λ™μ‹œν‚¬ 수 μžˆμŠ΅λ‹ˆλ‹€.

[μ‚¬μš©λͺ…λ Ήμ–΄]

--λ°±μ—…
BACUP DATABASE λ°μ΄ν„°λ² μ΄μŠ€λͺ… TO DISK = 'C:\TEMP\λ°μ΄ν„°λ² μ΄μŠ€λͺ….bak' WITH STATS = 10

--볡원
Restore Database test From Disk = 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\test.bak'
With Move 'test_data' To 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\test.mdf',
Move 'test_log' To 'C:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\test.ldf'

--λ°±μ—…νŒŒμΌ 검사
Restore FileListOnly From Disk = 'E:\ARTS\back\new_qst_bk090601.bak';
 

***μ°Έκ³ 
Microsoft SQL Server Management Studio μ‚¬μš©μ‹œ νŒŒμΌκ²½λ‘œμ™€ 이름이 μ œλŒ€λ‘œ μ•ˆ λ“€μ–΄κ°€λŠ” 뢀뢄이 있음.

[좜처] [mssql]데이터 베이슀 λ°±μ—…/볡원|μž‘μ„±μž zzagn902


restore database picasso from disk = 'C:\temp\picasso.bak' with move 'picasso_data' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\picasso_data.mdf',
move 'picasso_Log' to 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\picasso_Log.ldf'
728x90
LIST