Skip to Content
Former Member
May 13, 2009 at 08:10 AM

SQL server setup check - DB collector job not enabled -- after system copy



I did a backup/restore syscopy on SQL server 2005

i dropped the procedures and then run MSSPROCS

i see SAP_<sid>_<DB>_MSSQL_COLLECTOR in SQL server - it has run successfully and next run is in 20 mins

however in db12 when i go to configuration -> SQL server setup check i see this red message

DB collector job not enabled for <sid>

however when i go to performance- I/O operations i have values

Only thing is SQL keeps the old logical filenames it seems, can this be a problem

files are named <oldsid>data but the locations are correct