NCM DataBase

vistancm

Hi,

My Database is growing extra large and is difficult to find logs for a particular time because of this.

I would like to run an automated script, which would extract all the logs from the last day and either dump them to a file, that I can then upload to a different DataBase, or Better still, if it can export it to a different DataBase Directly ?

Is there a way we can do that in NCM, or do I need SQL Management Studio to do that for us ?

I am currently running SQL Server 2005 Express.

Thanks

cvachovecj

Hi,

NCM is generally not designed to manage servers and applications.

You can create a job of 'Execute Program' type and supply a script that would do the required task. However I don't see much value in using NCM here -- you can create such task under Windows Task Scheduler directly.

Regards,

Jiri