How can we help you today? How can we help you today?

Automatic creation of the Monitor Database

In our environment we will have a large number of base monitors. I have been looking into scripting of the installation. I have manages to get the basic base monitor installation to work but I have not found any way to automatically create the Monitor Database! I can't see what use scripted installation has if you at the same time can't create the monitor database. Anyone that knows if this is possible or not?
Peter_Akerlund
0

Comments

1 comment

Sort by
  • Sergio R
    Hi Peter,

    Yes, you can automate the initial installation of SQL Monitor, however the repository database needs to be pre-created.
     
    It's possible to do this in a script, for example you can use the Invoke-SqlCmd Powershell cmdlet.
     
    Here's a simple example:
    invoke-sqlcmd -query "CREATE DATABASE [RedgateMonitor]"
    Sergio R
    0

Add comment

Please sign in to leave a comment.