000843661 000__ 04810cam\a2200529Ii\4500 000843661 001__ 843661 000843661 005__ 20230306144904.0 000843661 006__ m\\\\\o\\d\\\\\\\\ 000843661 007__ cr\cn\nnnunnun 000843661 008__ 180621s2018\\\\nyua\\\\o\\\\\001\0\eng\d 000843661 019__ $$a1041896818$$a1042355445 000843661 020__ $$a9781484234563$$q(electronic book) 000843661 020__ $$a1484234561$$q(electronic book) 000843661 020__ $$z9781484234556 000843661 020__ $$z1484234553 000843661 035__ $$aSP(OCoLC)on1041152784 000843661 035__ $$aSP(OCoLC)1041152784$$z(OCoLC)1041896818$$z(OCoLC)1042355445 000843661 040__ $$aN$T$$beng$$erda$$epn$$cN$T$$dN$T$$dYDX$$dEBLCP$$dGW5XE$$dOCLCF$$dUAB 000843661 049__ $$aISEA 000843661 050_4 $$aQA76.9.D348 000843661 08204 $$a005/.86$$223 000843661 1001_ $$aBeard, Bradley,$$eauthor. 000843661 24510 $$aBeginning backup and restore for SQL Server :$$bdata loss management and prevention techniques /$$cBradley Beard. 000843661 264_1 $$aNew York :$$bApress,$$c[2018] 000843661 264_4 $$c©2018 000843661 300__ $$a1 online resource :$$billustrations 000843661 336__ $$atext$$btxt$$2rdacontent 000843661 337__ $$acomputer$$bc$$2rdamedia 000843661 338__ $$aonline resource$$bcr$$2rdacarrier 000843661 500__ $$aIncludes index. 000843661 5050_ $$aIntro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction to Backup and Restore Methodologies; Part I: Backups; Chapter 1: Full Backups; What Is a Full Backup?; Recovery Models; Backup Types; How Do Recovery Models Affect the Backup Types?; Preparing for a Full Backup; Back Up Database: General Tab; Transaction Log Examination; Manually Backing Up the Database; Summary; Chapter 2: Differential Backups; What Is a Differential Backup?; Differential Backup Dependency; Why Use Differential Backups?; Scenario Without Differential Backups 000843661 5058_ $$aScenario Running Differential BackupsAdding Differential Backups to a Backup Solution; Preparing for a Differential Backup; Running a Differential Backup; Taking a Backup via the GUI in SSMS; Validating a Backup via the GUI in SSMS; Taking a Differential Backup via T-SQL; Summary; Chapter 3: Transaction Log Backups; What Is a Transaction Log?; Viewing Transaction Log Status; Backing Up a Transaction Log; Transaction Log Backups via Script; Transaction Log Backups via SSMS; Back Up Database-General; Back Up Database-Media Options; Back Up Database-Backup Options; Summary 000843661 5058_ $$aChapter 4: Backup Solution ExamplesSetting Up the Maintenance Plan; Full Backup Configuration; Differential Backup Configuration; Transaction Log Backup Configuration; Configuring the Jobs; Summary; Part II: Restores; Chapter 5: Full Restores; What Is a Full Restore?; Restoring the Master Database; Start SQL Server in Single-User Mode; Restore SQL Server to Multiuser Mode; Restoring from a Full Backup; Full Restores with SSMS; Restoring to a Point in Time; Emergency Full Restore Example; Summary; Chapter 6: Differential Restores; What Is a Differential Restore?; Restoring Using SSMS 000843661 5058_ $$aRestoring Using T-SQLSummary; Chapter 7: Transaction Log Restores; Transaction Log Restore Fundamentals; Restoring Using SSMS; Restore Files and Filegroups-General; Restore Files and Filegroups-Options; Point-in-Time Restore/Recovery; Restoring Using Transact-SQL; Restore File and Filegroups Template; Summary; Chapter 8: Restore Solution Examples; Page Restores; Querying msdb..suspect_pages; Complete Database Restore Using T-SQL; Complete Database Restore Using SSMS; Database Snapshots; How Does a Database Snapshot Work?; Creating a Database Snapshot; Querying a Database Snapshot 000843661 5058_ $$aRestoring a Database SnapshotViewing Backup and Restore History; Summary; Part III: Complete Solutions; Chapter 9: Full Backup and Restore Solutions; Full Backup Plan in SSMS; Defining the Back Up Database Task Options; Scheduling the Full Backup; Updating the SQL Server Agent Job; General Tab; Steps Tab; Job Step Properties - Subplan_1 (General Tab); Job Step Properties - Subplan_1 (Advanced Tab); Schedules Tab; Alerts Tab; Notifications Tab; Setting Up an Operator; Testing the Full Backup Plan; Full Restore Plan in SSMS; T-SQL Restore Command; SQL Server Agent Restore Job 000843661 506__ $$aAccess limited to authorized users. 000843661 588__ $$aOnline resource ; title from PDF title page (viewed June 22, 2018). 000843661 650_0 $$aSQL (Computer program language) 000843661 650_0 $$aData recovery (Computer science) 000843661 650_0 $$aDatabase design. 000843661 650_0 $$aDatabase management. 000843661 77608 $$iPrint version: $$z1484234553$$z9781484234556$$w(OCoLC)1016047978 000843661 852__ $$bebk 000843661 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-3456-3$$zOnline Access$$91397441.1 000843661 909CO $$ooai:library.usi.edu:843661$$pGLOBAL_SET 000843661 980__ $$aEBOOK 000843661 980__ $$aBIB 000843661 982__ $$aEbook 000843661 983__ $$aOnline 000843661 994__ $$a92$$bISE