SQL Server Log Shipping Jung Suk Han Technical

SQL Server Log Shipping Jung Suk Han Technical Account Manager Premier Team Microsoft Korea

로그 전달은 무엇인가 Databa se Primary Server Transaction Log 복사 Databa se Secondary Server

로그 전달 구성요소 l 하드웨어 구성요소 Ø Ø Ø Primary server Secondary server Monitoring server

Log Shipping 구성요소 l Software 구성요소 Ø Ø Stored procedures Tables 로그 전달 모니터 작업(Job)

로그 전달 작동 방법 Monitoring Server Primary Server 1. Transaction log backed up Log Backup 2. Transaction log 복사 Logins 전송 Secondary Server(s) 3. Transaction log restored Log Backup

소프트웨어 고려사항 l 추천 Ø Ø SQL Server 2000 Enterprise Edition Operating systems: § § § l Windows NT 4. 0 Enterprise Edition (Service Pack 5) Windows 2000 Advanced Server Windows 2000 Datacenter Server 사용자 직접 Ø 모든 SQL Server 2000 가능

Network Load Balancing 을 통한 역할 변경 Client VIP DIP 1 NLB Cluster DIP 2 Primary SQL Server Log Shipping Secondary SQL Server

로그전달 기술과 특징 High-Availability Feature Log Shipping Standby type Warm Failure detection No, but with NLB … Automatic failover No, but with NLB … Protects against failed server process Yes, but … Protects against failed disk Yes, but … Metadata support Some system, all user schema and data for select databases Transactionally consistent Yes Transactionally current No, since last transactionlog backup Performance impact File copying on primary Time to failover Seconds, more to recover more thoroughly Locations Dispersed Complexity Some Multiple standby and/or backup nodes 32 with NLB, otherwise no limit Standby available for reporting, etc. Yes. Read-only access when logs are not being

© 2001 Microsoft Corporation. All rights reserved.