Brad's Sure Guide to SQL Server Maintenance Plans

Купить бумажную книгу и читать

Год: 2010

Автор: Brad M. McGehee

Издательство: Red Gate Books

ISBN: 1906434344

Язык: Английский

Формат: PDF

Качество: Изначально компьютерное (eBook)

Количество страниц: 277

Размер: 10мб

Описание: Millions of SQL Server instances run in the offices of small and medium-sized organizations and there are many "accidental" DBAs out there whose job it is to maintain them. Often, they find that they don't have the knowledge, experience, or critically the time, to perform the correct level of maintenance on their SQL Server databases, much as they might like to. This can mean poor performance and reduced availability. Regardless of the size of your organization, if your mission critical data becomes unavailable, then business will suffer greatly.

The Maintenance Plan Wizard and Designer allow you to configure and schedule eleven core database maintenance tasks, ranging from integrity checks, to database backups, to index reorganizations and rebuilds. Brad walks through every one of these tasks covering:...