tailieunhanh - Brad’s Sure Guide to SQL Server Maintenance Plans- P31

Brad’s Sure Guide to SQL Server Maintenance Plans- P31: SQL Server has a reputation as being a simple database application to install, configure, and maintain. This is a little misleading. SQL Server is a powerful relational database that can handle the needs of the largest organizations and, as such, its proper maintenance almost certainly requires the attention of an experienced DBA. | Chapter 12 Back Up Database Full Task For the typical database using one of the above strategies will allow you to perform full backups nightly. If your database is so large that neither of these two options will work then you probably shouldn t be using the Maintenance Plan Wizard to perform your backups. Backing up large databases 100 GB or more often requires more sophisticated backup strategies which are best handled using third-party tools T-SQL or PowerShell scripts. If your databases are large and if scripting and third-party tools are not an option then you may need to consider running full backups less frequently and performing differential backups covered in the next chapter on the days in between. Configuring the Back Up Database Full Task The Define Back Up Database Full Task screen shown in Figure is more complex than most of the Maintenance Plan Wizard screens we have seen up to this point. The first thing I want to point out is that the Backup type drop-down at the very top of the screen contains the value Full and is grayed out. That s because we are on the Back Up Database Full task and the Wizard is smart enough to complete the option for us. Database and Backup Component Selection The next option is the Database s drop-down box that we ve seen many times before and which you use to select the databases that you want to subject to full backups. In previous chapters we ve often seen Object and Selection options presented here allowing us to narrow the scope of a given task to defined objects within the database. In essence the Backup component options below the Database s box both of which are currently grayed out offer a comparable service for backups. When these options are not grayed out more on this shortly you can either select Database to back up the whole database which you will almost always want to do or you can select Files and filegroups to back up only specific files or filegroups within that database. 151 Chapter 12 Back Up .