Content Inside :
In an ideal world, hard drives and other hardware never fail, software is never defective, users do not make mistakes, and hackers are never successful. However, we live in a less than perfect world and we should plan and prepare to handle adverse events. In this whitepaper, we will discuss some of the best practices in Backup and Restore operations when using SQL Server 2005. In this whitepaper, we will cover: • What types of Backup and Restore options SQL Server offers • How to combine Backup and Restore types in a DRP • Best practices you should follow in your backup and restore strategy. You should begin designing your plan with a threat analysis. How much you are willing to pay is the backup and restore strategy. Threat Analysis (What can happen, and what you can afford to lose). Size: the third element to take into account is the size of the database. Obviously, large databases take longer to back up and restore than small databases. Very Large Databases (VLDB) may take weeks to restore in case of a total server collapse. You should consider the value, volatility, size and usage of your database when designing your data recovery plan. Backup Objectives : To recover lost data: This is the most obvious objective of a backup/restore plan. In case of an event, you will be able to recover the data that is lost. In the Database Backup dialog box, select the type of backup you want the server to perform, the backup destination path and the backup options. Partial backup is similar to File and Filegroup backups; they do not back up the entire database. Backup Strategies Combine different backup types to create a backup strategy. Use the Full Backup simple mode strategy only on development, read only, stage or system databases. Schedule the Log backup before the full backup.
Tags : partial backup, system databases, threat analysis, destination path, backup options, database backup, backup strategy, backup strategies, drp, sql server 2005, adverse events, perfect world, whitepaper, volatility, collapse
If you see unrelated pdf files with the description or copyrighted material published, please report to us, we'll correct/delete it it as soon as possible.NONE OF THOSE MATERIALS ARE HOSTED IN THIS SERVER NOR UPLOADED BY ME IN SOMEONE'S SERVERS. Read our DISCLAIMER for more detail.
We are neither affiliated with authors and brands nor responsible for its content and change of content.
Information contained herein is provided "as is" without warranty of any kind, either expressed or implied, including any warranty of merchantability or fitness for a particular purpose. In no event shall ANYONE be held liable for any loss of profit, special, incidental, consequential, or other similar claims.