SQL Server backup and restore school

Backup and restore best practices in SQL Server

It is essential every DBA have a proven and reliable backup and recovery plan for their SQL Server database, as data is the life blood of any organization. According to the Gartner report, two out of five enterprises that experience a disaster - such as the World Trade Center attack - go out of business within five years. This webcast series covers all aspects of SQL Server backup and recovery. In this first webcast, SQL Server MVP Hilary Cotter outlines overall backup and restore best practices in SQL Server, including:

• Recovery model choices: full, simple and bulk-logged
• Backup types: the advantages of one over the other
• Options for restoring backups
• Partial backup process

In this "best practices" get the key backup and recovery points: log shipping, backup frequency, database corruption, disk vs. tape and overall best practices.

Backup and restore commands in SQL Server

SQL Server MVP Hilary Cotter discusses the backup and restore commands included in both SQL Server 2000 and SQL Server 2005. Aspects covered here include these basic backup and restore commands:

• Backing up a transaction log
• Restoring from multiple devices
• Manipulating the media or backup device
• Partial database restore

Check out backup and restore commands and features available in both SQL Server 2000 and SQL Server 2005. In this podcast you'll learn about differential vs. full backups, transaction logs and the advantages of a media set.

SQL Server 2005 backup and restore features

There is a trend today to store more and more data, especially blobs of it, in databases. Terabyte databases are no longer a rarity. SQL Server 2005 addresses problems with backing up and restoring these very large databases and provides greater recovery options for the VLDBs, as well as the smaller databases. In this webcast, SQL Server MVP Hilary Cotter looks at the new features in SQL Server 2005 that will help a DBA provide high uptime. Features focused on in this final webcast include:

• Copy-only backups – allows you to copy databases for cloning purposes
• Mirrored tape backups – allows simultaneous tape backups up to four devices
• Torn page detection's replacement – checksum
• Transaction marks, which allow you to keep multiple databases in sync
• Restoring from a database snapshot

SQL Server 2005 provides high availability and minimizes database restore time (minimizes downtime). In this recording, you'll learn how transaction marks work, how to do a partial backup and restore and lastly, the verify options available in SQL Server 2005.

Related tips and guides:

ABOUT OUR EXPERT:

Hilary Cotter has been involved in IT for more than 20 years as a Web and database consultant. Microsoft first awarded Cotter the Microsoft SQL Server MVP award in 2001. Cotter received his bachelor of applied science degree in mechanical engineering from the University of Toronto and studied economics at the University of Calgary and computer science at UC Berkeley. He is the author of a book on SQL Server transactional replication and is currently working on books on merge replication and Microsoft search technologies.

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT SQL Server Backup and Recovery SQL Server Mailbag: Data restoration and DB property management Achieving high availability and disaster recovery with SharePoint databases How to 'do' SQL Server disaster recovery The keys to database backup protection for SQL Server Choosing a SQL Server disaster recovery solution Licensing a standby server for SQL Server replication Can I encrypt and restore a database backup in SQL Server 2005? 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 Backup and Recovery Research

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