Endpoint Protection

 View Only
  • 1.  Sql DB Maintenance

    Posted Mar 23, 2015 01:09 AM

    One of our SQLDB server is restarted today. What are the things that I need to check post this activity. We have more than 10 sepms.



  • 2.  RE: Sql DB Maintenance
    Best Answer

    Posted Mar 23, 2015 01:14 AM

    Hope this help

    https://www-secure.symantec.com/connect/articles/creating-maintenance-plan-sep-database-sql-server-2008

    Maintaining the database

    Article:HOWTO55337 | Created: 2011-06-29 | Updated: 2011-12-16 | Article URL http://www.symantec.com/docs/HOWTO55337


  • 3.  RE: Sql DB Maintenance

    Posted Mar 23, 2015 01:27 AM

    Im Looking for soemthing that I need to check post the reboot... 



  • 4.  RE: Sql DB Maintenance

    Trusted Advisor
    Posted Mar 23, 2015 01:29 AM

    Hello,

    After restart of SQL DB and In case you have 10 SEPM's on your environment, check the following things - 

    1) Are you able to Login to all the SEPM's?

    2) Are the SEPM's taking the latest definitions?

    3) Are the clients reporting to the respective SEPM's properly and taking latest updates?

    Here are few Articles which may assist you with the maintenance of the SQL DB - 

    Maintaining the database

    http://www.symantec.com/docs/HOWTO55337

    Creating a Maintenance Plan for SEP database - SQL server 2008

    https://www-secure.symantec.com/connect/articles/creating-maintenance-plan-sep-database-sql-server-2008

     



  • 5.  RE: Sql DB Maintenance

    Posted Mar 23, 2015 01:31 AM

    There is no prerequirent available in SEPM,You need to contact your SQL DB engineer
     



  • 6.  RE: Sql DB Maintenance

    Broadcom Employee
    Posted Mar 23, 2015 09:17 AM

    HI,

    Thank you for posting in Symantec community.

    There is not any pre-requisite but make sure you are able to browser SEPM SQL database.

    Open the SEPM console & make sure able to access Policies, Clients & Admin pages as well.