Home > SQL Server 2005 backup and recovery: 5 handy tips
Tutorial:
EMAIL THIS LICENSING & REPRINTS

SQL Server 2005 backup and recovery: 5 handy tips

19 Feb 2007 | SearchSQLServer.com

Expert advice on database administration
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google

Backup and recovery capabilities with SQL Server 2005 are relatively unchanged from SQL Server 2000, but there are several new features worthy of your attention. These features include database mirroring and database snapshots, which have been hailed as "gems" in terms of overall new features in this latest version of SQL Server. Below, you'll find five tips to help you navigate through backup and recovery enhancements in SQL Server 2005.

Piecemeal restore with SQL Server 2005
SQL Server 2005 extends the partial restore functionality with piecemeal restore, a feature that ultimately allows you to recover your entire database as your schedule permits. SQL Server expert Baya Pavliashvili details the benefits of piecemeal restore and outlines an example of how it is implemented.

Q&A: Database mirroring and its witness
Database mirroring in SQL Server 2005 will increase your system's availability by allowing a quick and automatic failover. This feature involves three SQL Server instances: the principal, mirror and witness. Edgewood Solutions' Greg Robidoux answers some common questions about the witness to help you better understand the role of this intricate team player in database mirroring.

SQL Server 2005: When and how to use Database Snapshots
Database Snapshots, a new feature in SQL Server 2005, lets you easily create a read-only copy of your database. Know the pros and cons of using this feature.

Partial backup options in SQL Server 2005
SQL Server 2005 offers new backup enhancements to help ease the pain of backing up only changed data. Contributor Serdar Yegulalp compares your options.

Online restore feature in SQL Server 2005
SQL Server 2005's online restore feature eliminates the need to have exclusive access to the database when restoring a backup. Learn about the restore procedure and how it requires the Enterprise or Developer Edition for implementation to take place.

More on SearchSQLServer.com

  • SQL Server Backup and Recovery Learning Guide
  • SQL Server backup encryption for improved security
  • Speed up SQL Server backup and restore time



    Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


    RELATED CONTENT
    SQL Server backup and recovery
    SQL Server errors, failures and other problems fixed from the trenches
    Get SQL Server log shipping functionality without Enterprise Edition
    SQL Server 2008 backup compression pros and cons
    SQL Server backups using SAN database snapshots
    Tips for scheduling and testing SQL Server backups
    Code to restore SQL Server databases in VB.NET
    Tricking SQL Server into making full database backups
    SAN considerations for your SQL Server environment
    Top 7 SQL Server backup and restore tips of 2007
    Retrieve deleted tables in SQL Server
    SQL Server backup and recovery Research

    SQL Server 2005 (Yukon)
    SQL Server consolidation: Why it's an optimization technique
    Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
    Using SQL Server datetime functions GETDATE, DATENAME and DATEPART
    SSIS error message due to installation problem on SQL Server 2005
    SQL Server data conversions from date/time values to character types
    Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
    How to configure Database Mail in SQL Server 2005 to send mail
    How to use rank function in SQL Server 2005
    Manage traces in SQL Server 2005 Analysis Services with XMLA commands
    Tutorial: SQL Server 2005 Analysis Services
    SQL Server 2005 (Yukon) Research

    Database Administrator
    SQL Server database design disasters: How it all starts
    SQL Server database design disasters: What not to do
    How to create a SQL Server linked server to DB2
    Virtual database storage for SQL Server: Friend or foe?
    How to restore SQL Server database to transition server during upgrade
    Storage area network (SAN) basics every SQL Server DBA must know
    SQL Server backups using SAN database snapshots
    Sarbanes-Oxley compliance checklist: IT security and SQL audits
    SQL Server 2005 log shipping setup using the wizard
    Track changes to SQL Server 2000 and 2005 with one simple utility

    RELATED GLOSSARY TERMS
    Terms from Whatis.com − the technology online dictionary
    rollback  (SearchSQLServer.com)

    RELATED RESOURCES
    2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
    Search Bitpipe.com for the latest white papers and business webcasts
    Whatis.com, the online computer dictionary


    • HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
    About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
    SEARCH 
    TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.

    TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




    All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy     		  TechTarget - The IT Media ROI Experts