Back and Restore Using Sql Server

Topics: Backup, Incremental backup, Backup software Pages: 264 (77856 words) Published: June 23, 2013
Backup and Restore of SQL Server Databases
SQL Server 2012 Books Online

Summary: This book describes the benefits of backing up SQL Server databases, basic backup and restore terms, and introduces backup and restore strategies for SQL Server and security considerations for SQL Server backup and restore. Category: Reference Applies to: SQL Server 2012 Source: SQL Server Books Online (link to source content) E-book publication date: June 2012

Copyright © 2012 by Microsoft Corporation
All rights reserved. No part of the contents of this book may be reproduced or transmitted in any form or by any means without the written permission of the publisher.

Microsoft and the trademarks listed at http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the Microsoft group of companies. All other marks are property of their respective owners. The example companies, organizations, products, domain names, email addresses, logos, people, places, and events depicted herein are fictitious. No association with any real company, organization, product, domain name, email address, logo, person, place, or event is intended or should be inferred. This book expresses the author’s views and opinions. The information contained in this book is provided without any express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Contents
Backup and Restore of SQL Server Databases ..................................................................................................... 6 Recovery Models .......................................................................................................................................................... 13 View or Change the Recovery Model of a Database .................................................................................. 16 Backup Overview .......................................................................................................................................................... 19 Restore and Recovery Overview ............................................................................................................................. 23 Plan and Perform Restore Sequences (Full Recovery Model) ................................................................. 30 Restart an Interrupted Restore Operation (Transact-SQL) ....................................................................... 32 Backup Compression .................................................................................................................................................. 33 Configure Backup Compression ......................................................................................................................... 35 Use Resource Governor to Limit CPU Usage by Backup Compression (Transact-SQL)................. 36 Full Database Backups................................................................................................................................................ 43 Create a Full Database Backup............................................................................................................................ 46 Back Up Database (General Page) ................................................................................................................. 54 Back Up Database (Options Page) ................................................................................................................. 57 Select Backup Destination................................................................................................................................. 61 Partial Backups .............................................................................................................................................................. 63 Full...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Essay about Sql Server
  • SQL Server Always on Essay
  • Microsoft SQL server Essay
  • Performance Tuning using SQL Server Dynamic Management Views Essay
  • Database Sql Server Research Paper
  • Functions in MS-SQL Server Essay
  • sql server notes Essay
  • SQL Server Notes Essay

Become a StudyMode Member

Sign Up - It's Free