Post reply

Starting/stopping SQL via DMO

  • October 22, 2001 at 8:24 pm

    #77550

    How can I use VBScript (and DMO) to stop the SQL Service service on a remote SQL 7 machine, copy trans logs from that machine, and then restart the SQL service?

  • October 23, 2001 at 5:55 am

    #419198

    Here is a starting point for you. See what you can do with this:

    On Error Resume Next

    Set oServer = New SQLDMO.SQLServer

    With oServer

    .LoginSecure = True

    .Connect "."

    .Shutdown

    End With

    Set oServer = Nothing

    'do the file copy here

    Set oServer = New SQLDMO.SQLServer

    oServer.Start False, "."

    Set oServer = Nothing

    Andy

    Andy
    SQLAndy - My Blog!
    Connect with me on LinkedIn
    Follow me on Twitter

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply