none
SQL jobs

    Question

  • How to configure SQL job for :

    1. Shrinking Database

    2. Rebuild index

    3. Timming SQL log.

    I am using SharePoint server 2010.


    chirag


    • Edited by Chirag2020 Tuesday, November 19, 2013 2:46 AM
    Tuesday, November 19, 2013 2:45 AM

Answers

  • Hi Chirag,

    You can create Maintenance Plans for the below:

    1. Shrinking Database

    2. Rebuild index

    3. Timming SQL log.

    You can refer the below snapshots to know how to create a maintenance plan:


    Thanks and Regards Alankar Chakravorty MCITP Database Administrator SQL Server 2008 MCITP Database Administrator SQL Server 2005

    Tuesday, November 19, 2013 5:45 AM