AnsweredAssumed Answered

Adding Coresight Database Backup to AF (PIFD) Database Backup SQL Server Job

Question asked by on May 2, 2017
Latest reply on May 9, 2017 by kfong

Salutations. I am hosting Coresight and AF on the same W2K12R2 server using SQL Server 2014 Standard Edition. I would prefer adding the Coresight backups to the AF (PIFD database) job or scheduling a second job if needed. I do not want to use a Windows scheduled task with a sql command file if I can avoid it.


Page 75 of the PI Coresight 2016 R2 Installation and Administration Guide says

     "You can use the following command to run the backup: sqlcmd -S SQLINSTANCE -d PI Coresight Database -Q "EXEC dbo.usp_backup @outpath = N'', @allwaysfullbackup =1;" -E


The stored procedures are in the PIFD database, not the Coresight database. How can I create a job in SQL Server to do this?