https://www.adminschool.net/wiki/ 2026-04-22T07:40:06+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module1&rev=1759498249&do=diff Lesson 1: Preparing to Install SQL Server 2005 Editions of SQL Server 2005 Edition Description Enterprise Highly scalable and available enterprise-level database server (OS도 엔터프라이즈로 해야 함.) Standard Database server for department-level applications (클러스터링 2노드까지 지원된다.) text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module2&rev=1759498249&do=diff Lesson 1: Planning Databases How Is Data Stored? * Page: 8KB -> Extent: 8 contiguous (8KB pages) -> Data file: .mdf or .ndf * Log file: .ldf How the Transaction Log Works * Data modification is send by application * Data pages are located in, or read into, buffer cache and modified text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module3&rev=1759498249&do=diff Lesson 1: Planning a Backup Strategy SQL Server Backup Types Backup Type Description Full 모든 데이터 파일과 트랜잭션 로그의 일부분을 백업한다. text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module4&rev=1759498249&do=diff Lesson 1: Overview of SQL Server Security What Are Principals? Level Principals Windows Windows local user account Windows domain user account Windows group SQL SQL Server login SQL Server role Database Database user Database role Application role text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module5&rev=1759498249&do=diff Lesson 1: Viewing Current Activity What Is Activity Monitor? * Graphical views of current user connectoins and locks * Process Info * Locks by Process * Locks by Object What Are Dynamic Management View and Functions? * Provide information about the current state of a server, for example text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module6&rev=1759498249&do=diff Lesson 1: Overview of Data Transfer What Is Data Transfer? * Extract from the source * Transform the data * Load to the destination What Is Data Transformation? Data transformation involves: * Changing the format of data * Aggregating data text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module7&rev=1759498249&do=diff Lesson 1: Automating Administrative Tasks in SQL Server 2005 Benefits of Automation * Reduced administrative workload * Reduced risk of overlooking vital maintenance tasks * Recuced risk of human error * Proactive management What Is the Maintenance Plan Wizard text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module8&rev=1759498249&do=diff Lesson 1: Overview of Replication What Is Replication? * Bring data closer to users * Site autonomy * Reduce locking confickts Server Roles in Replication * Publisher * Distributor * Subscriber Types of Replication * Snapshot replication text/html 2025-10-03T13:30:49+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:mssql:edu:maintain_sql2005:module9&rev=1759498249&do=diff Lesson 1: Introduction to High Availability Factors Affecting Availability * Software failures * Hardware component failures * Network failure * Power failure and natual disaster Considerations for Optimizing Database Availablity * Hardware component redundancy