O'Reilly logo

Beginning SQL Server 2008 Administration by Carmen Taglienti, Grant Fritchey, Robert E. Walters

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 8. Database Backup Strategies

SQL Server 2008 and the Windows platforms it runs on are very stable and safe technologies that can offer you years of uptime and service. However, things do go wrong. Software can have errors. Hardware can break. Users can make mistakes. Any one of these reasons and hundreds of others can lead to a loss of data that's important to you. To protect against the possibility of data loss, you're going to want some method of creating a copy of your database to store separately for use in the event of an emergency. This is called backing up the database.

There are a number of ways to back up your database, and each has its own strengths, weaknesses, and purpose. There are ways to back up only the parts of the database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required