Brad’s Sure Guide to SQL Server Maintenance Plans- P37: 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 15 Maintenance Cleanup Task File location Delete specific file Rte name Search folder and delete files based on an extension Folder File extension Q Include first-level subfolders Figure It would be very rare to only want to delete a single file. The second option is to Search folder and delete files based on an extension. This is the default option and the one you will use virtually all the time. It allows you to delete BAK TRN or TXT files based on the filename extension. This works well because BAK TRN and TXT files almost always have unique names assigned to them and using an extension is the easiest way to delete a lot of files in a single step. When you choose this option you also must provide two additional pieces of information. You must specify the folder where the files to be deleted are stored you can use the browse button for this and you must enter the file extension. If you chose Backup files earlier the default value here is BAK. If you want to delete TRN files instead then you will have to type in TRN manually. If you selected Maintenance Plan text reports earlier the default value will be TXT. You may also notice the option Include first-level subfolders. If you choose this option not only will the extension type you entered here be deleted in the root folder specified by Folder but so will any similar files in the first-level subfolders under this folder. This can be useful if you decide to use the Create a sub-directory for each database option when configuring the Database Backup tasks see Chapter 12 . Delete files older than. The last option is to specify the age of the files beyond which they will be removed using the Delete files based on the age of the file at task run time option as shown in Figure 181 Chapter 15 Maintenance Cleanup Task File age s Delete files based on the age of the file at task run time Delete files older than the following Figure Don t uncheck this option. This is another tricky option. First of .
