HOTSPOT
You have a SharePoint Server 2013 server farm that uses a Microsoft SQL Server 2012 database
server.
You need to automate the backup of the content databases.
From which node should you perform the configuration? (To answer, select the appropriate node in
the answer area.)
Explanation:
* Maintenance Plans
Creating SQL Server 2008 maintenance plans
You can programmatically apply many of the database maintenance operations that are discussed in
this article by implementing SQL Server maintenance plans. Maintenance plans can automate and
schedule essential tasks to protect your dat
a. By using maintenance plans in SQL Server 2008 or SQL Server 2005, an administrator can schedule
operations such as running database consistency checks, reorganizing indexes, or rebuilding indexes.
* To configure a SQL Server 2008 database maintenance plan
On the taskbar, choose Start, All Programs, Microsoft SQL Server 2008, SQL Server Management
Studio.In Object Explorer, connect to an instance of the SQL Server 2008 Database Engine and then expand
that instance.
Choose Management, right-click Maintenance Plans, and then choose Maintenance Plan Wizard.
Choose Next until you reach the Select Plan Properties page.
And later:
Select Maintenance Tasks pageDatabase maintenance for SharePoint 2010 Products
🙂