In addition to providing thorough explanations of how to install, configure, and maintain SQL Server 10 and SQL Server 11, this book also addresses system changes that may affect migration from prior generations of SQL Server, including data integrity features, performance, and tuning. Both novice and seasoned SQL Server users can focus on problemspots and pick up the ropes from real-world examples and exercises.
Installation, defining physical and Sybase-mirrored devices, transaction logging and modes, security, auditing, database backup and restore, troubleshooting, maintenance, and other subjects are covered in this authoritative handbook, which is intended to be used by all administrators. You ought to be able to complete any activity involving the setup or upkeep of a server after reading this book.