Tham khảo tài liệu 'mastering sql server 2000- p13', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | 620 I CHAPTER 16 BASIC ADMINISTRATIVE TASKS 13. Click OK on the message that informs you of success and then click Close on the Log Detail screen to complete the Wizard. The Copy Database Wizard is a simple tool that makes a complex task much easier. Summary In this chapter we talked about how to administer and maintain your databases so that they will always be running in top condition. The first topic to come up was backups there are many reasons to back up data natural disaster hardware malfunction even people with malicious intent. If you perform regular backups you can overcome these problems. There are four types of backups to help you thwart the evils that would claim your data. First there is the full backup the basis of all other backups which makes a copy of the entire database. Next the differential backup grabs all of the changes made to SUMMARY 621 the database since the last full backup. The transaction log backup came next and is very useful for quick backup strategy point-in-time restores and clearing the transaction log on a periodic basis. Finally there is the filegroup backup used to make backups of small chunks of very large databases. After a discussion of backups we hashed out the fine points of index maintenance. It is very important to keep your indexes up to snuff so that data access will always be fast. To keep them in top shape use DBCC SHOWCONTIG to determine fragmentation and then use CREATE INDEX with the DROP_EXISTING option or DBCC DBREINDEX to reconstruct fragmented indexes. After that we looked at the importance of monitoring the SQL Server event logs as well as the mechanics of doing so. Finally we discussed the Copy Database Wizard. Now that you know that you need to perform all of these tasks probably on a nightly or weekly basis wouldn t it be nice if you could have someone else do it for you In the next chapter we ll discuss automation you will learn how to make SQL Server do a lot of your work for you including backups. PART
