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
λ°±μ μ λͺ λ Ήμ΄λ‘ μννμλ €λ©΄
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