O'Reilly logo

Oracle Database Administration for Microsoft SQL Server DBAs by Michelle Malcher

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required