File Maintenance

Datafiles, log files, error logs, history logs, trace files—oh my! File maintenance is very important to the health of the database and maintaining a stable environment. Developing tasks and scripts will be useful for managing the many different files. We discussed backups and managing the backup files in Chapter 6. Here, we will look ways to maintain the datafiles, alert logs, and trace files.

Shrinking and Resizing Files

In SQL Server, you might shrink files as part of getting a production database to fit into a development environment. Especially if you are not running in FULL mode, large transaction files can be shrunk down to size. Also, if production backups have an issue, or a large transaction filled up more space than ...

Get Oracle Database Administration for Microsoft SQL Server DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.