close menu
Bookswagon-24x7 online bookstore
close menu
My Account
SQL Server Backup and Recovery: Tools and Techniques

SQL Server Backup and Recovery: Tools and Techniques

          
5
4
3
2
1

Out of Stock


Premium quality
Premium quality
Bookswagon upholds the quality by delivering untarnished books. Quality, services and satisfaction are everything for us!
Easy Return
Easy return
Not satisfied with this product! Keep it in original condition and packaging to avail easy return policy.
Certified product
Certified product
First impression is the last impression! Address the book’s certification page, ISBN, publisher’s name, copyright page and print quality.
Secure Checkout
Secure checkout
Security at its finest! Login, browse, purchase and pay, every step is safe and secured.
Money back guarantee
Money-back guarantee:
It’s all about customers! For any kind of bad experience with the product, get your actual amount back after returning the product.
On time delivery
On-time delivery
At your doorstep on time! Get this book delivered without any delay.
Notify me when this book is in stock
Add to Wishlist

About the Book

Written by a Microsoft insider who specializes in SQL Server enterprise deployments, SQL Server Backup and Recovery is the first comprehensive guide to protecting and restoring SQL Server databases. Organized to serve as both a hands-on tutorial and a long-term reference, it contains in-depth coverage of both SQL Server 2000 and 7.x -- as well as up-to-the-minute guidance on using Windows XP backup and recovery tools with SQL Server databases. Coverage includes: SQL Server architecture, fundamental backup and recovery principles, tools and scenarios, and SQL Server diagnostic tools. The book includes extensive sample code and scripts designed to help DBAs streamline and automate backup and recovery; as well as detailed information on the leading third party tools for SQL Server backup and recovery. All examples and screen shots are shown utilizing Windows XP, helping to extend the book's value for years to come. For every Microsoft SQL Server database administrator, and for every IT manager and professional responsible for protecting data stored on Microsoft SQL Server databases.

Table of Contents:
(NOTE: Each chapter ends with summary.) Introduction. Who This Book Is For. How This Book Is Organized. What You'll Need. Acknowledgements. 1. Planning, Architecture Overview, and Practical Experience. Planning Your Backup and Recovery. The Role of Backups. You're Only as Good as Your Last "Good" Backup. Types of Backups. How BACKUP Works. Databases You Should Back Up. Database Maintenance Plans. Backup Security. How RESTORE Works. Recovery Models. How Recovery Models Work. Setting Recovery Models. Changing Recovery Models. Limitations on Recovery Models. Recovery Model Backup Compatibility Matrix. Practical Experience. 2. Backing Up Data in SQL Server. SQL Server Tools. Backup Devices. Using Enterprise Manager to Define a Backup Device. Using Transact SQL to Define a Backup Device. Adding a Disk Backup Device with sp_addumpdevice. Adding a Tape Backup Device with sp_addumpdevice. Viewing Backup Devices. Dropping Backup Devices. Introduction to Backup Methods. Using the EM to Run a Backup. Using the Command Line to Back Up a Database. Backing Up a Database to Disk. Backing Up a Database to Tape. Making a Differential Database Backup. Backing Up Filegroups. Transaction Logs. Transaction Log Backup. Recovering the Tail of a Transaction Log. Backing Up a Whole SQL Server. Offline Backup. Backing Up an Entire Online Server. Backing Up a Table. Select Into. bcp. Running bcp. Data-Loading Strategies and bcp. DTS. DTS Performance Considerations. Flat File Backups. Performing Cold Backups of an NT File. Filesystem Backup: Architecture and Performance Considerations. Using sp_detach_db to Back Up. Scheduling Backups. Using SQL Server Agent with Your Backups. Using AT. Integrating E-Mail into Your Backup. Backup Performance and Operational Considerations. Striping with Tape Systems. Compression: Tape, OS, and Databases. Long-Term Storage. Compressed Volumes and SQL Server: Databases, Transaction Logs, and Backups. Monitoring the Completion of a Backup. Monitoring the Performance of a Backup. Tuning Up BACKUP. 3. Restoring Data to SQL Server. Appended Backups. Restoring a Database from Disk. Restoring a Database from Tape Using the Command Line. Large Restore from Tape. How to Restore a Database Using Transaction Logs. Assumptions. Process. Example. Recovery with Differential Backups. Assumptions. Process. Example. Restoring from a Differential Backup with Transaction Logs from a Tape Device. Restoring to a Point in Literal Time from Tape. Full Backup with Multiple Transaction Logs. Bringing It All Together: Moving Data Centers Using Standby Servers. Source Database Server. Target Standby Database Server. Other Uses for a Standby Server. Moving Database Files on a Restore. Restoring to a Marked Transaction. Results of Script. Restoring Files and Filegroups. Example. Recovering msdb. Example. Restoring Usernames and Logins. Recovering a Database with a Transaction Log Only. Example. 4. Recovering the master Database. Rebuilding and Recovering the master Database. Scenario. Restoring the master Database. Potential Problems in Rebuilding and Restoring the master Database. Recovering Other Databases after master Has Been Rebuilt. Using the RESTORE Command. Using the sp_attach_db Method. Notes on Logins and Users after a master Rebuild. Program to Generate Logins from the User Database. Remapping Orphaned Users. Recovering msdb. Process. Script. 5. Data Recovery Tools and Techniques. Establishing a Game Plan. Sizing Up the Situation. Common Diagnostic Tools. DBCC. SQLDIAG.EXE. Introduction to DBCC PAGE. DBCC PAGE Syntax. Finding and Repairing Corrupt Data with DBCC CHECKDB. Using Indexes to Recover Data. Case One. Case Two. Corruption That's Hard to Detect. Fixing Corrupt Nonclustered Indexes. Backing Up and Restoring Corruption. Retrieving Data Using DBCC PAGE. Using sp_attach_single_file_db to Recover an MDF File. 6. Log Shipping. Pros and Cons of Some High-Availability Solutions. Simple Log Shipping. Preliminary Steps. Creating a Maintenance Plan for Log Shipping. Explanation of the Files. SQL Agent Jobs. Maintenance Plans. Testing to See if Log Shipping is Really Working. Removing Log Shipping. Two Secondary Servers. Creating a Maintenance Plan for Log Shipping with Two Secondary Servers. Primary/Secondary to Primary/Secondary. Failing Over: Network Load Balancing Router. No Recovery Mode and Standby Mode. Log Shipping Monitor. Viewing the Log Shipping Monitor. Role Change to the Standby Log Shipping Server. Failing Over if Both Servers Are Accessible. Logins and Users During Log Shipping. Failing Over in an Emergency: Only the Destination Server Is Up. Re-Establishing Log Shipping After Recovering the Primary. Good Ideas Before Failing Over. Potential Problems During Log Shipping. Appendix A: An Efficient and Flexible Method for Archiving a Data Base. Appendix B: ER Diagrams. Appendix C: Acronyms and Abbreviations. Bibliography. Index.


Best Sellers



Product Details
  • ISBN-13: 9780130622983
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Prentice Hall
  • Height: 234 mm
  • No of Pages: 320
  • Sub Title: Tools and Techniques
  • Width: 177 mm
  • ISBN-10: 0130622982
  • Publisher Date: 12 Dec 2001
  • Binding: Paperback
  • Language: English
  • Spine Width: 21 mm
  • Weight: 603 gr


Similar Products

How would you rate your experience shopping for books on Bookswagon?

Add Photo
Add Photo

Customer Reviews

REVIEWS           
Click Here To Be The First to Review this Product
SQL Server Backup and Recovery: Tools and Techniques
Pearson Education (US) -
SQL Server Backup and Recovery: Tools and Techniques
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

SQL Server Backup and Recovery: Tools and Techniques

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book
    Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    New Arrivals



    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!
    ASK VIDYA