PrepAway - Latest Free Exam Questions & Answers

which node should you perform the configuration?

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

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
* Maintenance Plans
Creating SQL Server 2008 maintenance plansYou 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 data. 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
1. On the taskbar, choose Start, All Programs, Microsoft SQL Server 2008, SQL Server Management Studio.
2. In Object Explorer, connect to an instance of the SQL Server 2008 Database Engine and then expand that instance.
3. Choose Management, right-click Maintenance Plans, and then choose Maintenance Plan Wizard.
4. Choose Next until you reach the Select Plan Properties page.
And later:
Select Maintenance Tasks page

Database maintenance for SharePoint 2010 Products


Leave a Reply