Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. Youall get the focused information you need to save time and get the job doneawhether at your desk or in the field! Get fast facts to: Manage SQL Server services and clients Configure, manage, and tune servers Implement policy-based management Administer security and access Monitor server activity and tune performance Automate maintenance Perform backups and recoveryCleanup History. Historical data about backup and restore, SQL Server Agent, and maintenance plan operations is stored in the msdb database. When the history cleanup task runs, any historical data that is older than four weeks is deleted onanbsp;...
|Title||:||Microsoft SQL Server 2012 Pocket Consultant|
|Publisher||:||Pearson Education - 2012-02-15|