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
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.