tailieunhanh - Hướng dẫn học Microsoft SQL Server 2008 part 101

Một kỹ thuật phổ biến là để xoay một bộ năm băng cho các backup hàng tuần và thiết lập một trong sáu băng cho các sao lưu hàng ngày còn lại. Các băng hàng tuần sẽ được gắn nhãn Sunday1, Sunday2, và như vậy, và các băng hàng ngày sẽ được gắn nhãn Thứ Hai, Ba, Thứ Tư, thứ Năm, thứ Sáu và thứ Bảy. | Part VI Enterprise Data Management A common technique is to rotate a set of five tapes for the weekly backups and another set of six tapes for the remaining daily backups. The weekly tapes would be labeled Sunday1 Sunday2 and so on and the daily tapes would be labeled Monday Tuesday Wednesday Thursday Friday and Saturday. Palindromes also represent a great method for rotating backup tapes. A palindrome is a word phrase or number that s the same backward or forward such as kayak or drab as a fool aloof as a bard. Some numbers when reversed and added to themselves will create a palindrome for example 236 632 868. Palindromes have a rich history In ancient Greece they inscribed Nipson anomemata me monan opsin meaning wash the sin as well as the face on fountains. Using four tapes labeled A through D a backup rotation might be ABCDCBA ABCDCBA . Alternately the palindrome method can be implemented so that each letter represents a larger interval such as A for daily B for weekly C for monthly and D for quarterly. Rotating backup tapes off site is an important aspect of recovery planning. Ideally a contract should support an off-site recovery location complete with server and workstations. Performing backup with Management Studio The first backup must be a full database backup to begin the backup cycles. You can perform a database backup from Management Studio selecting the database to be backed up. From the database context menu or from the database Summary Page select Tasks O Back Up to open the Back Up Database form shown in Figure 41-3. The backup source is configured in the General page Database The database to be backed up. By default this is the current database in Management Studio. Backup type The type of backup Full Differential or Transaction Log. If the database is set to the simple recovery model transaction log will not be available. For full or differential backups the whole database or selected files and filegroups can be backed up. Copy Only Backup Allows