In this SQL Server backup and recovery school you'll get overall best practices, learn commands for backup and restore functions and be introduced to SQL Server 2005 features – all via webcasts and podcasts.
|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
- Download Webcast 1
In this "best practices" get the key backup and recovery points: log shipping, backup frequency, database corruption, disk vs. tape and overall best practices.
- Download Podcast 1
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
- Download Webcast 2
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.
- Download Podcast 2
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
- Download Webcast 3
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.
- Download Podcast 3
Related tips and guides:
- Disaster recovery features in SQL Server 2005:
- Database administrators must have a reliable backup and recovery plan for their SQL Server databases. After five years in development, see how SQL Server 2005 provides greater backup and recovery options. Microsoft MVP Hilary Cotter explains the new features including mirrored backup media sets, log shipping, replication and database mirroring.
- SQL Server 2005 backup and recovery -- 5 handy tips:
- Backup and recovery with SQL Server 2005 include 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. Below, you'll find five tips to help you navigate through backup and recovery enhancements in SQL Server 2005.
- Restore basics -- How to restore using T-SQL commands:
- SQL Server Enterprise Manager may be a quick and easy way to run backups and restores, but T-SQL commands offer much greater flexibility. Find out how to script your SQL Server backups or restores.
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.