عنوان

Beginning backup and restore for SQL Server :

شابک

1484234553

شابک

1484234561

شابک

9781484234556

شابک

9781484234563

شابک اشتباه

1484234553

شابک اشتباه

9781484234556

عنوان اصلي

Beginning backup and restore for SQL Server :

نام عام مواد

[Book]

ساير اطلاعات عنواني

data loss management and prevention techniques /

نام نخستين پديدآور

Bradley Beard.

محل نشرو پخش و غیره

New York :

نام ناشر، پخش کننده و غيره

Apress,

تاریخ نشرو بخش و غیره

[2018]

تاریخ نشرو بخش و غیره

©2018

نام خاص و کميت اثر

1 online resource :

ساير جزييات

illustrations

متن يادداشت

Includes index.

متن يادداشت

Intro; 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.

متن يادداشت

Chapter 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.

متن يادداشت

Restoring 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.

متن يادداشت

Restoring 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.

متن يادداشت

Scenario 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.

بدون عنوان

0

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

بدون عنوان

8

متن يادداشت

Be guided through the techniques to back up and restore databases and files in SQL Server. Multiple techniques are presented for ensuring the integrity and consistency of database backups, as well as the reliability and manageability of restoring from backups. In today's data-driven world, the most important asset that a company has is its data. Data recovery strategies can be wide ranging; from the practically non-existent backup without verification to a very complex, distributed, and redundant system. An important objective for any database administrator is data loss prevention, and in a catastrophic data loss event, pre-defined data recovery techniques must be employed in order to get the databases back up and running efficiently and quickly. Using a tutorial method of teaching, Beginning Backup and Restore for SQL Server explores the many facets behind the principles of backing up and restoring data from your database, and then shows practical application methods for getting the work done quickly and correctly. This book is an essential guide toward discovering the correct path to protecting the data for your organization. What You'll Learn: Be instructed on backup and restore techniques and principles Understand the importance of a fully implemented backup plan in SQL Server Agent Integrate backup and restore techniques into an existing environment Consider space and time requirements for backup and restore operations Master the principles for common deployment types.

منبع سفارش / آدرس اشتراک

00152887

شماره انبار

9781484234556

عنوان

Beginning backup and restore for SQL Server.

شماره استاندارد بين المللي کتاب و موسيقي

9781484234556

موضوع مستند نشده

Data recovery (Computer science)

موضوع مستند نشده

Database design.

موضوع مستند نشده

Database management.

موضوع مستند نشده

SQL (Computer program language)

موضوع مستند نشده

COMPUTERS-- Databases-- General.

موضوع مستند نشده

Data recovery (Computer science)

موضوع مستند نشده

Database design.

موضوع مستند نشده

Database management.

موضوع مستند نشده

Databases.

موضوع مستند نشده

SQL (Computer program language)

موضوع مستند نشده

COM-- 021000

موضوع مستند نشده

UMT

موضوع مستند نشده

UN

شماره

ويراست

شماره رده

مستند نام اشخاص تاييد نشده

Beard, Bradley

تاريخ عمليات

20200823032024.0

قواعد فهرست نويسي ( بخش توصيفي )

pn

نام الکترونيکي

نوع ماده

[Book]

تكميل شده

Y